[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] HA for high insert volume
From:       John Sequeira <john_seq () hotmail ! com>
Date:       2002-10-30 21:27:33
[Download RAW message or body]

I'm looking for some suggestions for setting up a remote failover 
Postgres instance (warm spare).  In my situation,  the db to be failed 
over has a very high # of INSERTS (it does a lot of logging),  and it 
seems like there might be too much overhead using something like usogres 
or one of the replication options.  We expect it to grow very quickly to 
the point at which a full dump and load is not practical (5-15G).

Are people having luck using something like rsync in this instance? 
This document :
http://www.taygeta.com/ha-postgresql.html
describes using rsync,  but in the case where the #  of inserts is low.

Is that working for people,  or is there a better way to do this?
We're willing to consider commercial solutions but would prefer OSS.

Thanks in advance,

John Sequeira


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]