| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sexton, Joe | 2002-11-14 17:33:12 | Re: problem in installing PostGreSql on windows |
| Previous Message | Richard Pais | 2002-11-14 16:37:58 | initdb hangs |