Skip site navigation (1) Skip section navigation (2)

Re: Cross Platform Continous Archiving and Replication

From: Selva manickaraja <mavles78(at)gmail(dot)com>
To: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Cross Platform Continous Archiving and Replication
Date: 2011-02-11 00:00:13
Message-ID: AANLkTi=b07FQybN7Oxkqsuca02Rpxr3-_fB4rzd+HxVW@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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
>

In response to

Responses

pgsql-admin by date

Next:From: FabricioDate: 2011-02-11 01:19:33
Subject: mapping libraries
Previous:From: CS DBADate: 2011-02-10 20:02:02
Subject: Re: Postgres on NAS/NFS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group