Re: Can WAL files be shipped to multiple servers?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Steeles <steeles(at)gmail(dot)com>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can WAL files be shipped to multiple servers?
Date: 2010-07-23 22:43:21
Message-ID: 1279924943-sup-701@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kerry Sainsbury 2010-07-23 22:48:49 Re: JASPA (JAva SPATial) for PostgreSQL and H2 released
Previous Message Michael A. Peters 2010-07-23 22:20:20 pg_dump, shemas, backup strategy