Re: [GENERAL] receive and transmit streaming replication at same time

2010-09-29 Thread Vick Khera
On Wed, Sep 29, 2010 at 5:22 AM, 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. -- Sent via pgsql-general mailing list (pgsql-general@postgr

Re: [GENERAL] receive and transmit streaming replication at same time

2010-09-29 Thread Thom Brown
On 29 September 2010 10:22, 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

Re: [GENERAL] receive and transmit streaming replication at same time

2010-09-29 Thread Grzegorz Jaƛkiewicz
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailp

[GENERAL] receive and transmit streaming replication at same time

2010-09-29 Thread post
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