Do you get same error when using psql? On Mon, Jun 9, 2014 at 11:25 AM, Bwana Lawi <mail2lawi@gmail.com> wrote:
Hi guys,
I have pgsql 9.3 on Linux Mint, fresh install - both OS and DB.
While setting up roles and dbs using the pgAdmin III client, the client crashed - as in it just closed itself. I opened it again but I havent managed to login to the db using postgres user since. I keep getting the error:
*Error connecting to the server: FATAL: password authentication failed for user "postgres"* *FATAL: password authentication failed for user "postgres"*
a) I have checked pg_hba.conf (which shouldn't even matter since I was able to connect to the db before the crash)
Current setting(I have also tried with peer and ident):
*# Database administrative login by Unix domain socket* *local all postgres trust*
- I have run the* psql -c "ALTER USER postgres WITH PASSWORD 'pass'" *numerous times
- I have restarted the db multiple times as well
- The roles I had just created can log in perfectly, unfortunately they are 'powerless'
What should I do?
The DB is literally empty so I dont stand to lose anything by re-installing but I'd prefer that to be the last option
Mr. Lawi
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke