From: | David Goodenough <david(dot)goodenough(at)btconnect(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dumpall -g problem |
Date: | 2003-04-30 10:55:10 |
Message-ID: | 20030430105505.B8A8C474E42@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a Postgresql 7.2.2 installation, and I am having a problem with
the results of doing a pg_dumpall -g.
It dumps out three users, ignoring the fourth. If I connect to template1
with psql and do select * from pg_users I get four, and actually this fourth
is the one who owns all the user DBs, so I know it exists. It does dump
the postgres ID.
I also have a 7.3.2 system and that reports all except the postgres ID but
including the one that the 7.2.2 system ignores. Ignoring the postgres ID
makes some sense in that when you install Postgresql it gets set up by
default so it will be there anyway.
The missing one has a user ID of 101 if that is of any significance.
Is this a known problem? Is there a workaround?
Thanks in advance
David
From | Date | Subject | |
---|---|---|---|
Next Message | Gerhard Hintermayer | 2003-04-30 11:08:25 | Re: Backend memory leakage when inserting |
Previous Message | Richard Huxton | 2003-04-30 09:26:51 | Re: rules question |