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.

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

thanks

share|improve this question

migrated from stackoverflow.com Jan 5 '12 at 22:16

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

1  
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: postgresql.org/docs/8.3/interactive/backup-file.html –  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

 
discard

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