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
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
Hi Melvin, No, I wasn't getting the same error on psql. The issue was that somehow the account had expired. Am back online now On Tue, Jun 10, 2014 at 9:38 AM, melvin obiri <obirimelvin@gmail.com> wrote:
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
_______________________________________________ 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
participants (2)
-
Bwana Lawi -
melvin obiri