> 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.
> Now I inadvertently blew away that user postgres and I can't connect to
> anything anymore. That is because there were no other users yet.
>
> I even blew away the database and ran initdb again. It says 'postgres' not
> in pg_shadow.
>
> My pg_hba.conf has local all trust.
initdb should recreate everything. I would delete the /data directory
before doing initdb, maybe.
--
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
