Recovering Postgre DB
Posted:
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
Posted:
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