| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Steeles <steeles(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can WAL files be shipped to multiple servers? |
| Date: | 2010-07-23 16:54:27 |
| Message-ID: | AANLkTimD2UxLnT61h_=g6k+T0JK3N4HbH6X9_E+vj6k-@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jul 23, 2010 at 18:36, Steeles <steeles(at)gmail(dot)com> 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2010-07-23 16:56:37 | Re: Can WAL files be shipped to multiple servers? |
| Previous Message | John R Pierce | 2010-07-23 16:52:22 | Re: Bitmask trickiness |