Hi

We do it with Skytools. In addition to replication with Londiste it hs lot's
of other useful scripts for keeping online database small and healthy.

Asko


On 10/31/07, Joanne Salerno <[EMAIL PROTECTED]> wrote:
>
> I have two Postgres databases (7.4 and 8.24) within the same network on
> LINUX platforms. Data sources go to both databases.
>
> I'd like to set up one as a near real-time backup to the operational
> database.  Is it possible to incorporate a trigger upon update (or
> insert) on the operational 8.24 database to initiate an update (or
> insert) on the backup 7.4 database?
>
> How do most people set up a near real-time backup database?  Perhaps
> there is something else that acts like a trigger.  Any suggestions would
> be helpful.
>
> Thanks.  Joanne
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

Reply via email to