Unable to login to DB because server probably doesn't run

A special forum dedicated to our PT4 for Mac OS X users

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Unable to login to DB because server probably doesn't run

Postby alpyn » Thu May 23, 2013 6:24 pm

Hello,

I was purging some hands from database, my computer freezed out and I had to restart it.

After that, I can not use PT4, because Postgres doesn't run. I can't see any Postgres process in Activity Monitor. When I start PT4, this window appears — http://cl.ly/image/0z2i1N1o0V09. When I click on Configure Defaults and fill out this window http://cl.ly/image/0F0v13142S1z, it shows me only "Unable to connect to database" info.

I'd also tried to log in to Postgres in pgAdmin III. I was unable to connect again, this warning http://cl.ly/image/2Y3p1s0F0S1s appeared.

I really do not know what to do at this point. I could probably set a new database, but I really want to save my data.

Could you help me, please?
alpyn
 
Posts: 17
Joined: Wed Feb 15, 2012 6:10 pm

Re: Unable to login to DB because server probably doesn't ru

Postby kraada » Fri May 24, 2013 8:28 am

Open Applications -> Utilities -> Terminal and type the following and paste the output here please:
ps auxw | grep -i postgres
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to login to DB because server probably doesn't ru

Postby alpyn » Fri May 24, 2013 10:15 am

postgres 235 0.0 0.1 2470640 6056 ?? SN 12:41PM 0:03.44 /System/Library/Frameworks/CoreServices.framework/Frameworks/Metadata.framework/Versions/A/Support/mdworker -s mdworker -c MDSImporterWorker -m com.apple.mdworker.shared
postgres 207 0.0 0.0 2465740 1100 ?? S 12:40PM 0:00.02 /usr/sbin/cfprefsd agent
postgres 203 0.0 0.0 2483820 1548 ?? S 12:40PM 0:00.22 /usr/sbin/distnoted agent
postgres 197 0.0 0.0 2471372 860 ?? Ss 12:40PM 0:00.08 /sbin/launchd
alpyn 2843 0.0 0.0 2432768 600 s000 S+ 4:14PM 0:00.00 grep -i postgres
alpyn
 
Posts: 17
Joined: Wed Feb 15, 2012 6:10 pm

Re: Unable to login to DB because server probably doesn't ru

Postby kraada » Fri May 24, 2013 10:46 am

Looks like PostgreSQL is not running. Run this command:
ls /Library/PostgreSQL/
and that will tell us what version you've got installed.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to login to DB because server probably doesn't ru

Postby alpyn » Fri May 24, 2013 11:06 am

9.0
alpyn
 
Posts: 17
Joined: Wed Feb 15, 2012 6:10 pm

Re: Unable to login to DB because server probably doesn't ru

Postby kraada » Fri May 24, 2013 4:26 pm

Please try uninstalling and reinstalling PostgreSQL as explained in this guide and that should get things working for you again.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PT4 for macOS

Who is online

Users browsing this forum: No registered users and 13 guests

cron