up vote 0 down vote favorite
share [g+] share [fb]

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

link|improve this question
1  
This should go to serverfault – fge Jan 5 at 9:02
Did you tried PG_DUMP? – simonecampora Jan 5 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 at 9:22
then you can try the filesystem backup: postgresql.org/docs/8.3/interactive/backup-file.html – simonecampora Jan 5 at 9:47
I Havn't this dir: /usr/local/pgsql/data – Mohsen6558 Jan 5 at 10:04
feedback

migrated from stackoverflow.com Jan 5 at 22:16

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

1 Answer

up vote 0 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard