Page 1 of 2

Unable to login to database (postgres).

PostPosted: Thu Mar 28, 2013 2:47 am
by Shamwoww
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 :)

Re: Unable to login to database (postgres).

PostPosted: Thu Mar 28, 2013 8:17 am
by kraada
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.

Re: Unable to login to database (postgres).

PostPosted: Thu Mar 28, 2013 11:08 am
by Shamwoww
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.

Re: Unable to login to database (postgres).

PostPosted: Thu Mar 28, 2013 1:10 pm
by kraada
Open Finder and click Go -> Go to Folder and paste in:
/Library/PostgreSQL/
and click OK. Does that show you any data?

Re: Unable to login to database (postgres).

PostPosted: Fri Mar 29, 2013 6:05 am
by Shamwoww
No.

"The folder can't be found".

Re: Unable to login to database (postgres).

PostPosted: Fri Mar 29, 2013 8:00 am
by kraada
Then PostgreSQL is not installed properly. Please run this installer and that should install it for you.

Re: Unable to login to database (postgres).

PostPosted: Sun Mar 31, 2013 6:43 am
by Shamwoww
Downloaded.

Still same message.

Re: Unable to login to database (postgres).

PostPosted: Sun Mar 31, 2013 9:04 am
by WhiteRider
Did the installer complete OK or did you get any problems?

Re: Unable to login to database (postgres).

PostPosted: Thu Apr 04, 2013 3:27 am
by Shamwoww
Installer completed but nothing changed.

Re: Unable to login to database (postgres).

PostPosted: Thu Apr 04, 2013 7:41 am
by kraada
You still don't see that folder existing?