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:[EMAIL PROTECTED] > Enviada em: quarta-feira, 5 de julho de 2006 00:42 > Para: [EMAIL PROTECTED] > Cc: pgsql-general@postgresql.org > 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/ > > > ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
