Unable to login to database (postgres).

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

Unable to login to database (postgres).

Postby Shamwoww » Thu Mar 28, 2013 2:47 am

Once again i have a problem with postgres and using PT.

I run a Mac and quit using PT3 after i kept having database issues. This time i thought i'd try PT4's free trial and see how it goes this time. Same thing again.

I have an error popup when i try open PT4:

Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"

How do i fix this?

Thanks :)
Shamwoww
 
Posts: 11
Joined: Mon Jun 18, 2012 10:26 pm

Re: Unable to login to database (postgres).

Postby kraada » Thu Mar 28, 2013 8:17 am

You'll need to use whatever password you used at creation time for that account. If you can't remember it, edit the pg_hba.conf file (we explain how to edit the file here) and change "md5" to "trust" (no quotes) and then restart your machine and then you should be able to connect regardless of what password you use.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to login to database (postgres).

Postby Shamwoww » Thu Mar 28, 2013 11:08 am

The password i used is the same i'm trying to connect with and it won't work.

When i try to perform those commands, none of it appears. There is no postgreSQL folder in my library, only in my applications. When i use the command "ifconfig" no IP appears in my terminal.
Shamwoww
 
Posts: 11
Joined: Mon Jun 18, 2012 10:26 pm

Re: Unable to login to database (postgres).

Postby kraada » Thu Mar 28, 2013 1:10 pm

Open Finder and click Go -> Go to Folder and paste in:
/Library/PostgreSQL/
and click OK. Does that show you any data?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to login to database (postgres).

Postby Shamwoww » Fri Mar 29, 2013 6:05 am

No.

"The folder can't be found".
Shamwoww
 
Posts: 11
Joined: Mon Jun 18, 2012 10:26 pm

Re: Unable to login to database (postgres).

Postby kraada » Fri Mar 29, 2013 8:00 am

Then PostgreSQL is not installed properly. Please run this installer and that should install it for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to login to database (postgres).

Postby Shamwoww » Sun Mar 31, 2013 6:43 am

Downloaded.

Still same message.
Shamwoww
 
Posts: 11
Joined: Mon Jun 18, 2012 10:26 pm

Re: Unable to login to database (postgres).

Postby WhiteRider » Sun Mar 31, 2013 9:04 am

Did the installer complete OK or did you get any problems?
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Unable to login to database (postgres).

Postby Shamwoww » Thu Apr 04, 2013 3:27 am

Installer completed but nothing changed.
Shamwoww
 
Posts: 11
Joined: Mon Jun 18, 2012 10:26 pm

Re: Unable to login to database (postgres).

Postby kraada » Thu Apr 04, 2013 7:41 am

You still don't see that folder existing?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 12 guests

cron
highfalutin