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