Re: [GENERAL] Restoring from filesystem backup

2005-11-11 Thread Dianne Yumul
Thanks for the response. does the global directory exist on the drive you are syncing from? If so ... then it's a problem with your rsync. check the options you are using with the rsync command. check the rsync configurations in /etc/rsyncd.conf on the drive. what user are you running the rsy

Re: [GENERAL] Restoring from filesystem backup

2005-11-11 Thread Dianne Yumul
Thanks for the quick response. We do both pg_dump and file system backups, and I agree that pg_dump is the way to go. I thought I'd practice restoring from a filesystem backup though since I've never done that before. Thank you. On Nov 10, 2005, at 6:07 PM, Scott Frankel wrote: I'm no expe

Re: [GENERAL] Restoring from filesystem backup

2005-11-10 Thread Scott Frankel
I'm no expert, but I did just accomplish a restore from backup; so at least I can help you with your second question. pg_dump is the animal you'll want to use to create your backup. I use it wrapped in a script that automatically timestamps and names the output appropriately. Args looks

[GENERAL] Restoring from filesystem backup

2005-11-10 Thread Dianne Yumul
Hello to everybody. I just have a couple of newbie questions. I'm trying to restore our databases from a file system backup. The backups are done with rsync, the postgresql service is stopped before backups are done on the server. The system is Fedora Core 4 with Postgresql 8.0.3. Now back