Re: log shipping/DB recovery with PostgreSQL 7.4

Porell, Chris wrote:
> 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.

www.slony.info

>
>
>
> -----Original Message-----
> From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
> Sent: Tuesday, May 08, 2007 4:41 PM
> To: Porell, Chris
> Cc: 'pgsql-general(at)postgresql(dot)org'
> 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/