Postgres Pro
Downloads
Home   >   mailing lists

Re: Backup Database - Mailing list pgsql-sql

From Asko Oja
Subject Re: Backup Database
Date
Msg-id ecd779860711050130j60ea6246gd9c4b8e4b3be7ae0@mail.gmail.com
Whole thread Raw
In response to Backup Database  (Joanne Salerno <joanne.salerno@noaa.gov>)
List pgsql-sql
Tree view
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 <joanne.salerno@noaa.gov> 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

pgsql-sql by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Returning the total number of rows as a separate column when using limit
Next
From: Kenneth Gonsalves
Date:
Subject: changing encoding of a postgres database