| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Magnus Hagander <magnus(at)hagander(dot)net> |
| Cc: | Steeles <steeles(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can WAL files be shipped to multiple servers? |
| Date: | 2010-07-23 16:56:37 |
| Message-ID: | 4C49C9C5.1090400@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 07/23/2010 09:31 AM, Magnus Hagander wrote:
> On Fri, Jul 23, 2010 at 18:29, Steeles<steeles(at)gmail(dot)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.
>
>
Just curious does this restriction also apply to Hot Standby in 9.0?
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2010-07-23 17:53:47 | Re: Can WAL files be shipped to multiple servers? |
| Previous Message | Magnus Hagander | 2010-07-23 16:54:27 | Re: Can WAL files be shipped to multiple servers? |