Page 1 of 1

Recovering Postgre DB

PostPosted: Sat Mar 15, 2008 10:42 am
by dmandrea
Hi guys! I have a problem. My notebook doesn't work anymore, and the only way to use it is throgut windows recude mode and i can't run PostgreeSQL; how can i rebuld my databases on my new pc ? copiing files dooens't wok.. any suggestion?

thanks

Re: Recovering Postgre DB

PostPosted: Sat Mar 15, 2008 2:31 pm
by APerfect10
You can try running [url=http://www.postgresql.org/docs/8.3/interactive/app-pgdump.htmlsh7]pg_dump[/urlsh7] from the command line. This script is located in your PostgreSQL/<version>/bin directory.

If that does not work, you may need to try backing up the entire file system. Please see [url=http://www.postgresql.org/docs/8.3/interactive/backup-file.htmlsh7]File System Level Backup[/urlsh7].

If you need further assistance with either of these, please let me know. I have never personally need to backup using the second method; however, I am sure I can still help.

Best regards,

Derek