mirorring databases with small time gaps

From: Jean-Christophe ARNU (JX) <jc(dot)arnu(at)free(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: mirorring databases with small time gaps
Date: 2002-02-25 08:21:25
Message-ID: 20020225032125.6c073677.jc.arnu@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all pg admins,

here is the problem we're encountering now. We've got a pgsql database server, logging informations (such as alarms, week-events and so on) for a measure system. This database is mainly fed by a collect daemon which inserts/update values in tables and generates alarms (inserts).
The alarms are ack'ed by differents programs (Java though JDBC or python).

The problem is that this database server only holds 7 days datas then drop then.

A second server with more disk space, is running pg and measure and generated alarms are "inserted" into its tables by the daemon (duplicating inserts).

The problem, is that we would like to avoid to modify each client program which updates alarms (for acknoledgement) but we would like to sync 7 days database with the bigger one.

The constraint is that data difference time gap should be reduced under 5 minutes.

So I wondered if replication server will work (but we should replicate only update/inserts not delete from the 7 days to bigger database). What about the server load with such a replication?
Is there a trivial way to "log & replicate" insert/update on a given table? Do we have to modify all the client application in order to make them ack alarms in 7 days database and in bigger one also?

By advance, thank you.

--
Jean-Christophe ARNU
s/w developer
Paratronic France

Browse pgsql-admin by date

  From Date Subject
Next Message Zeugswetter Andreas SB SD 2002-02-25 12:04:30 Re: Backup and Recovery (revisited)
Previous Message Henry 2002-02-24 07:44:50 callable statement please