Re: RES: [GENERAL] Phantom groups

2006-07-05 Thread Chris
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 / switch

Re: [GENERAL] Phantom groups

2006-07-05 Thread Scott Marlowe
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 crea

RES: [GENERAL] Phantom groups

2006-07-05 Thread Carlos H. Reimer
ira, 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 > > behavi

Re: [GENERAL] Phantom groups

2006-07-04 Thread Chris
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

[GENERAL] Phantom groups

2006-07-03 Thread Carlos H. Reimer
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