Page 1 of 1

Database can"t connect after housekeeping

PostPosted: Sun Oct 27, 2013 11:53 am
by roo_400
I did the entire housekeeping and the Indexing part was taking over 30 hours so I closed it since I wanted my HUD for my session today.

Now, the database can't connect to the server. I get to choose between my databases but can't click on either one. The only option available is "New" to create a new database.

Here is the error I get when clicking on "New":

Unable to create PostgreSQL database:
PT3_2013_10_27_114337
Reason: Unable to login to database (template1). Reason:
could not connect to server: Connection refused is the
server running locally and accepting connections on Unix
domain socket "/tmp/ .s.PGSQL.5432"?

Re: Database can"t connect after housekeeping

PostPosted: Sun Oct 27, 2013 12:28 pm
by WhiteRider
That suggests that PostgreSQL is not running. The first thing to do is to reboot - that will often get PostgreSQL running again.

I think you're using a Mac?
At a Terminal run ps aux | grep -i postgres and paste your output here.

Re: Database can"t connect after housekeeping

PostPosted: Sun Oct 27, 2013 1:06 pm
by roo_400
Rebooting worked

Sorry for being such a newb lol

fwiw I didn't understand your last sentence

Re: Database can"t connect after housekeeping

PostPosted: Mon Oct 28, 2013 7:56 am
by kraada
If rebooting worked, you don't need to worry about it :)

highfalutin