Обсуждение: Phantom groups
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. How could I fix it? Reimer
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/
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@gmail.com] > Enviada em: quarta-feira, 5 de julho de 2006 00:42 > Para: carlosreimer@terra.com.br > 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/ > > >
On Tue, 2006-07-04 at 22:41, Chris wrote: > 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. Alternately, if you give pg_dumpall the -g switch, you'll get just that global user data.
Carlos H. Reimer wrote: > 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. pg_dumpall *does* dump all the permissions properly. What options / switches exactly are you using with pg_dumpall? -- Postgresql & php tutorials http://www.designmagick.com/