Re: Real time replication of PG DBs accross two servers - any experiences? - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Real time replication of PG DBs accross two servers - any experiences?
Date
Msg-id c6dere$4cp$1@floppy.pyrenet.fr
Whole thread Raw
In response to Real time replication of PG DBs accross two servers - any experiences?  (Bradley Kieser <brad@kieser.net>)
List 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



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with inserts from subselects
Next
From: Glenn MacGregor
Date:
Subject: delete cascade question