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.
