Thanks for the info. What, then, is the best way to achieve my goal of having a "standby" DB that can be kept within 15 minutes or so in sync with the primary? periodic pg_dump/restore? Unfortunately, I can't upgrade right now. -----Original Message----- From: Joshua D. Drake [mailto:jd@xxxxxxxxxxxxxxxxx] Sent: Tuesday, May 08, 2007 4:41 PM To: Porell, Chris Cc: 'pgsql-general@xxxxxxxxxxxxxx' Subject: Re: [GENERAL] log shipping/DB recovery with PostgreSQL 7.4 Porell, Chris wrote: > I am trying to bring up a disaster recovery database using a cold-copy of > the datafiles on a different machine. I've got all WAL files since this > copy was made. Is it possible to make a 7.4 DB apply the WALs to the DB > when I bring it up? No, you need to be running >8.x. Sincerely, Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ----------------------------------------- IMPORTANT: The sender intends that this electronic message is for exclusive use by the person to whom it is addressed. This message may contain information that is confidential or privileged and exempt from disclosure under applicable law. If the reader of this message is not an intended recipient, be aware that any disclosure, dissemination, distribution or copying of this communication, or the use of its contents, is prohibited. If you have received this message in error, please immediately notify the sender of your inadvertent receipt and delete this message from all data storage systems. Thank you.
