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

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

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.