
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