Thread: log shipping/DB recovery with PostgreSQL 7.4
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? Thanks! Chris ----------------------------------------- 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.
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/
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@commandprompt.com]
Sent: Tuesday, May 08, 2007 4:41 PM
To: Porell, Chris
Cc: 'pgsql-general@postgresql.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/
-----------------------------------------
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.
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@commandprompt.com]
> Sent: Tuesday, May 08, 2007 4:41 PM
> To: Porell, Chris
> Cc: 'pgsql-general@postgresql.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/