RE: [ADMIN] Automation/scheduling of Backup stratetgy

2000-10-20 Thread Michael Ansley
Title: RE: [ADMIN] Automation/scheduling of Backup stratetgy You mean WAL. When your server goes down, you can restore from the last backup, and then reapply the WAL to recreate all transactions that were in committed between the backup and the crash. WAL is due for 7.1, I believe. Cheers

RE: [ADMIN] Automation/scheduling of Backup stratetgy

2000-10-19 Thread Matthew H. North
]]On Behalf Of Trewern, Ben Sent: Thursday, October 19, 2000 9:32 AM To: [EMAIL PROTECTED] Subject: RE: [ADMIN] Automation/scheduling of Backup stratetgy It is already built in. Use pg_dump or pg_dumpall when online. Only problem is OIDs and large objects. pg_dump -o to keep OIDs not sure about