Postgres password change

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Postgres password change

Postby xarin » Fri Jun 06, 2014 1:03 pm

I had to change the password for my PostgresSQL. When I logged into PT3 after doing so, I gave it the new password, but now it's giving me errors saying it can't access the my database. It set up a new database just fine, but I can't get into all my hand histories.
xarin
 
Posts: 19
Joined: Thu Apr 03, 2008 5:24 pm

Re: Postgres password change

Postby kraada » Fri Jun 06, 2014 1:32 pm

Go into Database -> Database Management and choose your old database and click Remove and say OK. Then click New and Browse Databases. Use the proper credentials and you should be able to select your old database and Connect to it and everything should be fine after that.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Postgres password change

Postby xarin » Fri Jun 06, 2014 1:41 pm

When I click browse databases, it says:

Unable to login to database (template1). Reason FATAL: password authentication failed for user "postgres"
xarin
 
Posts: 19
Joined: Thu Apr 03, 2008 5:24 pm

Re: Postgres password change

Postby xarin » Fri Jun 06, 2014 1:42 pm

Nevermind, figured it out. :) Thanks
xarin
 
Posts: 19
Joined: Thu Apr 03, 2008 5:24 pm

Re: Postgres password change

Postby kraada » Fri Jun 06, 2014 1:58 pm

Glad to hear it :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 2 guests

cron