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

Hot Syncing Databases and using Heartbeat for failover

From: "Schmidt-1, Pamela" <Pamela(dot)Schmidt-1(at)ksc(dot)nasa(dot)gov>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Hot Syncing Databases and using Heartbeat for failover
Date: 2002-11-14 16:44:31
Message-ID: ADBBD04CAC52D411ABA700508BADE5AE08D94257@KSCEMS004 (view raw, whole thread or download thread mbox)
Lists: pgsql-cygwin
Is anyone currently using a PostgreSQL database and hotsyncing to a standby?  I'm currently running Linux 7.3, Heartbeat .4.9e, PostgreSQL, and OpenNMS.  Here's how it works:

OpenNMS creates a database called opennms and data is periodically polled (every 5 minutes) and stored in the opennms database.

Heartbeat is running (with ipfail) so that any disruption of service the failover occurs.  Upon failover Heartbeat starts opennms and the services are displayed without interuption but, the database is not current.

Does anyone know of a way to synchronize the databases on a five minute interval without stopping the database service performing the sync and then bringing the database back up?  I need a real-time syncronization that will perform a failover with heartbeat and still maintain the integrity of the data within the database.

Can someone help?????
Pam Schmidt

pgsql-cygwin by date

Next:From: Sexton, JoeDate: 2002-11-14 17:33:12
Subject: Re: problem in installing PostGreSql on windows
Previous:From: Richard PaisDate: 2002-11-14 16:37:58
Subject: initdb hangs

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