Steeles wrote:
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?
Not while it's in recovery mode. If you upgrade to the soon to be released PostgreSQL 9.0, it's possible to bring the server up in Hot Standby mode, which will allow pg_dump to execute against the standby. Note that you have to be careful to tune the standby for this, as pg_dump will act like a really long running transaction and there's a risk of it being canceled if activity on the master conflicts with what it's trying to dump.
-- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
