Re: Cross Platform Continous Archiving and Replication

[Selva manickaraja <mavles78@xxxxxxxxx>]

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@xxxxxxxxxx>

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