receive and transmit streaming replication at same time

From: post(at)bastian-s(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: receive and transmit streaming replication at same time
Date: 2010-09-29 09:22:45
Message-ID: 835395ef3a9a77b9912449ab70952011.squirrel@webmail.kontent.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2010-09-29 09:41:50 Re: receive and transmit streaming replication at same time
Previous Message Dave Page 2010-09-29 08:47:25 Re: PostgreSQL 9 Mac OS X one-click install - PL/perl broken