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

I Use Centos 5 and boot from linux rescue PostgreSQL Fail on start and I need my database on Postgresql How I can backup postgresql database without use service (copy database files and ...)


share|improve this question

migrated from Jan 5 '12 at 22:16

This question came from our site for professional and enthusiast programmers.

This should go to serverfault –  fge Jan 5 '12 at 9:02
Did you tried PG_DUMP? –  simonecampora Jan 5 '12 at 9:17
pg_dump: Connection to Database "root" failed: could not connect to server : no such file or directory us the server running locally and accepting connections on unix domain socket "/tmp/.s.ogsqk.5432" –  Mohsen6558 Jan 5 '12 at 9:22
then you can try the filesystem backup: –  simonecampora Jan 5 '12 at 9:47
I Havn't this dir: /usr/local/pgsql/data –  Mohsen6558 Jan 5 '12 at 10:04

1 Answer 1

Copy all your database files (data and config) into a new system, with a new database (same version). That's all.

share|improve this answer

Your Answer


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