Re: Backup Database

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(dot)salerno(at)noaa(dot)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
>