On 07/23/2010 09:31 AM, Magnus Hagander wrote:
On Fri, Jul 23, 2010 at 18:29, Steeles<steeles@xxxxxxxxx> wrote:
I am working on shipping WAL files, can WAL files do one-to-many shipping?
The target PG instances are running in the recovery mode waiting for the WAL
files.
Yes. Just copy the files to multiple machines, the slaves are
completely independent.
also, once the target PG database receives WAL files and update its own
database, can I run pg_dump to dump all the data when it is in recovery
mode?
No.
Just curious does this restriction also apply to Hot Standby in 9.0?
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
