redundant databases for 24hx7d operation - Mailing list pgsql-admin

From Giorgio Verde
Subject redundant databases for 24hx7d operation
Date
Msg-id 9av33q$ptp$1@news.tht.net
Whole thread Raw
List pgsql-admin
I am a newbie in postgres and I need to organise a database mirroring
library for continous operation with very short recovery time in case one
of the 2 database copies fails.. As I saw that this problem has already
been experienced by more than one in this newgroup, i would like to ask for
some suggestions of the best ways to solve the problem.

I am currently thinking of using trigger functions for this problem.. is
this a good approach? What is the best approach for database resync after
failure?

Thank you very much,
Giorgio Verde


pgsql-admin by date:

Previous
From: Grant
Date:
Subject: Re: Encryption.
Next
From: epsi
Date:
Subject: Postgresql 7.1rc4 on Mac OS X: Success!