On Fri, Jul 23, 2010 at 18:36, Steeles <steeles@xxxxxxxxx> wrote: > 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. You can't switch back. Well, you can - by setting up the replication again from scratch, meaning from a new base backup. That also means that if the master crashes while you're backing up your slave, it will be out of date. > Will it break the relationship between source and target? Do I need to > re-configure it in order to receive the WAL files? Yes. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general