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

Re: Real time replication of PG DBs accross two servers - any experiences?

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Real time replication of PG DBs accross two servers - any experiences?
Date: 2004-04-24 10:17:17
Message-ID: c6dere$4cp$1@floppy.pyrenet.fr (view raw or flat)
Thread:
Lists: pgsql-admin
Bradley Kieser wrote:
> Hi All,
> 
> I desperately need to set up a real time replication of several 
> databases (for failover) between two servers. Last time I looked at the 
> PG replication it wasn't yet production level. I wonder if anyone on 
> this list is doing this successfully and if you won't mind sharing your 
> experience and giving me any tips that you may think would be handy from 
> a real world perspective I would very much appreciate it.
> 
> I am 100% Linux-based, in case that makes a difference! I have also 
> considered using the CODA files system in case the replication isn't 
> quite up to production levels still.

We are using a SAN server, and 2 nodes running a Red Hat  HA.

Regards
Gaetano Mendola



In response to

pgsql-admin by date

Next:From: Ross FerrisDate: 2004-04-24 15:32:38
Subject: Re: How configure Oracle 9i not case sensitive...
Previous:From: Tom LaneDate: 2004-04-24 03:02:16
Subject: Re: Problem with inserts from subselects

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