Thread: receive and transmit streaming replication at same time

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).


Thanks,
Bastian

no you can't
but you have have multiple clusters running at the same time on the
same box. Just set them up on different ports, and in different
directories.

On 29 September 2010 10:22,  <post@bastian-s.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

On Wed, Sep 29, 2010 at 5:22 AM,  <post@bastian-s.de> wrote:
> Is it possible to set up ONE PostgreSQL 9 to serve as a streaming
> replication provider (Master) and receiver (client) at the same time?
>

You can implement such a replication using Slony-1.