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.
Bruce, if you want it I had at the time created a tar ball of the data
directory in it's currupt state, it is small and I *think* I still have
it some where, if you like I can email it to you, it is for 6.4.2.
I have been going to look at it, but have been totally swamped with less
important things :-)
Make it a great day
Terry Mackintosh <[EMAIL PROTECTED]> http://www.terrym.com
sysadmin/owner I'm excited about life! How about YOU!?
Professional Web Hosting and site design to include programming
Proudly powered by R H Linux, Apache, PHP, PostgreSQL, other Open Source
-----------------------------------------------------------------------
Only if you know where you're going can you get there.
