Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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


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.