Page 1 of 1

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

PostPosted: Thu May 23, 2013 6:24 pm
by alpyn
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?

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

PostPosted: Fri May 24, 2013 8:28 am
by kraada
Open Applications -> Utilities -> Terminal and type the following and paste the output here please:
ps auxw | grep -i postgres

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

PostPosted: Fri May 24, 2013 10:15 am
by alpyn
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

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

PostPosted: Fri May 24, 2013 10:46 am
by kraada
Looks like PostgreSQL is not running. Run this command:
ls /Library/PostgreSQL/
and that will tell us what version you've got installed.

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

PostPosted: Fri May 24, 2013 11:06 am
by alpyn
9.0

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

PostPosted: Fri May 24, 2013 4:26 pm
by kraada
Please try uninstalling and reinstalling PostgreSQL as explained in this guide and that should get things working for you again.

highfalutin