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
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
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
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
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