[GENERAL] Backup questions

2004-07-29 Thread Jason Tesser
I have 2 questions. 1. What is the best way to back up a production box running Postgres nightly? 2. I thought the best way was to create a script that would use pg_dump to create a dump every night and then use restore if I need to. I did this but I am having a problem. Apparently there were

[GENERAL] Backup questions

2004-07-29 Thread Jason Tesser
I have 2 questions. 1. What is the best way to back up a production box running Postgres nightly? 2. I thought the best way was to create a script that would use pg_dump to create a dump every night and then use restore if I need to. I did this but I am having a problem. Apparently th