Re: Cross Platform Continous Archiving and Replication

I am using Postgresql 9.0 with its native replication and continous
archiving. As per my understanding the primary and secondary communication
via log files for continous archiving and direct postgres engine to engine
communication for replication. These should not be a problem since I can use
the pgadmin_III in Windows to perform transaction in the postgresql database
residing on RedHat. Please clarify.

2011/2/10 Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>

> On Thu, 2011-02-10 at 16:39 +0800, Selva manickaraja wrote:
> > We are in the process of setting up
> > (a) Continous Archiving between machineA and machine B (Both Linux)
> > (b) Replication between machineA and machineC (Both Linux)
> > (c) Continous Archiving between machineA and machineD (Linux and
> > Windows)
> >
> > We got the (a) and (b) working and are in trial mode. We are not sure
> > if (c) will work between different OS. Any clues or opinion on how we
> > should approach this.
>
> WAL replication won't work between different OS'es, and between
> different arches. It even won't work between different Linux flavors.
> You need to use a replication solution, like Slony.
>
> Regards,
> --
> Devrim GÜNDÜZ
> EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
>