Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

So. I have a problem. PostgreSQL 8.4 won't start or restart without any output given.

But it worked for 3 monthes until hosting provider doesn't rebooted server. Now it is completly broken. It wan't start and doesn't give any output or log.

pg_dump: [archiver (db)] connection to database "postgres" failed: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Now I want to backup (or just start pgsql socket) my database to reinstall postgesql. How?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Soooo. Here is the solution.

The problem was my postgresql (for some reason :o) didn't have any clusters creates.

So I created one:

pg_createcluster 8.4 main

Now let's find something silimar to old data folder: find / -name 'PG_VERSION'

Here it is – /usr/local/pgsql/data/. Now edit postgresql.conf in your cluster folder.

You have to replace data_directory varaible value with old folder.

Now you can restart your server. Everything will work fine.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.