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.
Will it break the relationship between source and target? Do I need to re-configure it in order to receive the WAL files? On Fri, Jul 23, 2010 at 12:31 PM, Magnus Hagander <mag...@hagander.net>wrote: > On Fri, Jul 23, 2010 at 18:29, Steeles <stee...@gmail.com> 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. > > > -- > Magnus Hagander > Me: http://www.hagander.net/ > Work: http://www.redpill-linpro.com/ >
