From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | post(at)bastian-s(dot)de |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: receive and transmit streaming replication at same time |
Date: | 2010-09-29 09:42:57 |
Message-ID: | AANLkTikjReu4mtVUf287PZxqjV-AN9Bp8Z5dpx4fsCpR@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 29 September 2010 10:22, <post(at)bastian-s(dot)de> wrote:
> Hello List,
>
> a lot of recherche and no answer so far. So my question to you:
>
> Is it possible to set up ONE PostgreSQL 9 to serve as a streaming
> replication provider (Master) and receiver (client) at the same time?
>
> Can i configure both to
> * accept 'insert into ...' & stream that changes out (usual master)
> AND
> * catch streaming from another streaming ?
>
> My application:
> * Two servers acquire measurements at the same time into one table.
> * No risk of conflicts!
> * No need of standby skills (for now).
It sounds like you're after a multi-master setup, but that's not
possible (at least not at the moment). Unless you're talking about
chainable slaves where slaves can stream data to other slaves, which I
think it also not currently possible.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
From | Date | Subject | |
---|---|---|---|
Next Message | Leonardo Francalanci | 2010-09-29 09:52:45 | Postgresql for a CEP app |
Previous Message | Grzegorz Jaśkiewicz | 2010-09-29 09:41:50 | Re: receive and transmit streaming replication at same time |