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/

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.

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/