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

On Mon, Mar 12, 2012 at 5:31 AM, Nie, Guocong <guocong(dot)nie(at)capgemini(dot)com> wrote:
> Hi Team,
>
> I am doing postgresql 9.1  replication , the Master database is on GNU/Linux
> operation system , the Slave  database is on Windows 32 bit system.  But
> when I copy the Master database from Linux to Windows , then I am unlucky to
> bringup database on windows system.
>
> 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.

If you require replication across platforms, you will need to look
into one of the other replication systems such as Slony, Londiste, or
Bucardo.
--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"