Re: Can WAL files be shipped to multiple servers? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Can WAL files be shipped to multiple servers?
Date
Msg-id 1279924943-sup-701@alvh.no-ip.org
Whole thread Raw
In response to Re: Can WAL files be shipped to multiple servers?  (Steeles <steeles@gmail.com>)
List pgsql-general
Excerpts from Steeles's message of vie jul 23 12:36:41 -0400 2010:
> Thanks for the quick reply.
>
> so if I switch target database from recovery mode to normal mode and do
> pg_dump to backup, then switch it back to recovery mode.

The only way to switch back is to have a prior filesystem-level snapshot
before you put it in normal mode, and restore to that snapshot after
pg_dump is complete.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Finding last checkpoint time
Next
From: "Michael A. Peters"
Date:
Subject: pg_dump, shemas, backup strategy