Re: postgresql 9.1 replicaiton query ( GNU/Linux replicate to Windows)

Christopher Browne <cbbrowne@gmail.com> wrote:
> Nie, Guocong <guocong.nie@capgemini.com> wrote:

>> Could you please let me know how can I replicate database from
>> Linux to Windows ?
>
> The built-in replication requires that you are using the same
> version of PostgreSQL on the same OS platform.  That doesn't seem
> to be documented as clearly as one might have hoped it would be.

Yeah, on a quick search I didn't find anything under replication
itself.  Unless I'm missing something, one would need to know that
it was more-or-less the same as PITR backup, and find this to find a
clue:

http://www.postgresql.org/docs/9.1/interactive/warm-standby.html#STANDBY-PLANNING

It does seem like there should be more, although I'm not sure
exactly what or where.

> If you require replication across platforms, you will need to look
> into one of the other replication systems such as Slony, Londiste,
> or Bucardo.

There is a Wiki page listing and comparing available products:

http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling

-Kevin