Re: [Postgres-xc-developers] NEED same help

[Ashutosh B. <ash...@en...>]

Hi Afonso,
I am including the hackers mailing list for the best answer.

AFAIU, you need to replicate your database between two Postgres-XC
clusters? OR one Postgres-XC cluster and other PG instance? Is that right?


You may
1. Setup 1 to 1 streaming replication between all the nodes of Postres-XC.
I am not sure about GTM to GTM, but they may not be required. Right now
there is no single channel streaming replication supported by XC, since the
WALs are not available at central point.

2. Use trigger based replication between the two Postgres-XC instances.
That might be costly.


On Wed, Jul 17, 2013 at 4:23 PM, Afonso Bione <aag...@gm...> wrote:

> Dear friend,
>
>     I installed Moodle using the master GTM and I  would like to replicate the
> database on another machine using a Coordinator, but when I create the
> database on another machine, I get an error message
> could send me an example of how to use the postgresxc using the same basis of
> the database on several computers with a GTM and Coordinator
> .
>          Thanks again
>



-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Postgres Database Company