| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Chris <dmagick(at)gmail(dot)com> |
| Cc: | carlosreimer(at)terra(dot)com(dot)br, pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Phantom groups |
| Date: | 2006-07-05 19:11:30 |
| Message-ID: | 1152126690.13851.39.camel@state.g2switchworks.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jochem van Dieten | 2006-07-05 19:23:40 | Re: [JDBC] Is what I want possible and if so how? |
| Previous Message | Chris Browne | 2006-07-05 18:36:35 | Re: Notes on converting from MySQL 5.0.x to PostgreSQL |