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.) 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. Any clues out there? -- Peter Eisentraut PathWay Computing, Inc.
- Re: [ADMIN] Blew away postgres user -- now can't connect Peter Eisentraut
- Re: [ADMIN] Blew away postgres user -- now can't con... Bruce Momjian
- [ADMIN] 6.5 hung sk . list
- Re: [ADMIN] 6.5 hung Vadim Mikheev
- Re: [ADMIN] Blew away postgres user -- now can't... Terry Mackintosh
- Re: [ADMIN] Blew away postgres user -- now c... Bruce Momjian
- Re: [ADMIN] Blew away postgres user -- now can't... Peter Eisentraut