Sorry, I would like to say pg_dumpall and not pg_dump. --no-privileges is an option but I need to restore the privileges. There are a lot of them in the system, many many objects and privileges. > -----Mensagem original----- > De: Chris [mailto:dmagick@xxxxxxxxx] > Enviada em: quarta-feira, 5 de julho de 2006 00:42 > Para: carlosreimer@xxxxxxxxxxxx > Cc: pgsql-general@xxxxxxxxxxxxxx > Assunto: Re: [GENERAL] Phantom groups > > > Carlos H. Reimer wrote: > > Hi, > > > > I´m planning to migrate from 7.4 to 8.0.7 and I discovered some strange > > behavior during migration. > > > > pg_dump inserted GRANT to phantom groups. They do not exist in pg_group; > > > > When the script created by pg_dump is processed by psql during restore, > > these GRANTs produce a lot of errors. > > pg_dump won't include users and groups. pg_dumpall would include that > information but of course includes all databases. > > If you use the --no-privileges option with pg_dump it won't include the > grant/revoke statements. > > http://www.postgresql.org/docs/8.0/static/app-pgdump.html > > -- > Postgresql & php tutorials > http://www.designmagick.com/ > > >
