From: Richard Huxton <dev@archonet.com>
To: Stef Telford <stef@Chronozon.dyndns.org>
To: pgsql-sql@postgresql.org
Subject: Re: Archival of Live database to Historical database
Date: Tue, 30 Jan 2001 09:09:18 -0000
Message-ID: <00cb01c08a9c$559a9820$1001a8c0@archonet.com> (raw)
References: <200101292000.f0TK0os06683@oberon.hades>
From: "Stef Telford" <stef@Chronozon.dyndns.org>
> Hello everyone,
> I have hit on a limit in my knowledge and i am looking for
> some guidance. Currently I have two seperate databases, one for
> live data, the other for historical data. The only difference really
> being that the historical data has a Serial in it so that the tables
> can keep more than one 'version history'.
>
> What i would like to do, is after my insert transaction to the
> live database, i would like the information also transferred to the
> historical one. Now. I can do this via perl (and i have been doing it
> this way) and using two database handles. This is rather clumsy and
> I know there must be a 'better' or more 'elegant' solution.
Not really (AFAIK) - this crops up fairly regularly but there's no way to do
a cross-database query.
You could use rules/triggers to set a "dirty" flag for each record that
needs copying - but it sounds like you're already doing that.
If you wanted things to be more "real-time" you could look at LISTEN/NOTIFY
- Richard Huxton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, stef@Chronozon.dyndns.org
Subject: Re: Archival of Live database to Historical database
In-Reply-To: <00cb01c08a9c$559a9820$1001a8c0@archonet.com>
References: <200101292000.f0TK0os06683@oberon.hades> <00cb01c08a9c$559a9820$1001a8c0@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox