> Hi all
>
> Bruce Momjian wrote:
> >
> > > I had two identical postgres users in my pg_users table. (Why does that
> > > keep occurring? I also had to versions of each table I made.)
> >
> > I would love to know how that happens. It is pg_dumpall causing it?
> > Please try to find out.
>
> Ya, this is now the 4th or 5th? *reported* case of this on differing
> platforms and it dates back to 6.4.2 code at least.
>
> It is not likely that it was caused by loading a currupt dump file, as
> this cuased the errors that origanelly brought this to my attention...
> errors about this or that already exists and it refused to create the
> 2nd copy of things.
> Now the pg_dump will dump the dups, but that in it self would seem
> correct as they seem to really be there.
I suspect pg_dumpall, which tries to handle not duplicating the postgres
user. Is that the one that is duplicated?
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
