On Wednesday 06 Oct 2004 12:20 pm, Glen Eustace wrote:
> I thought I had seen something that indicated that v8 was going to
> provide a means to mirror databases without needing all the triggers
> etc. I downloaded beta 3 but couldn't see anything that would do this.
>
> My goal is to mirror a database from one server to another, hopefully
> from the logs so that there is nothing added to the database. The
> mirrored db will be used by the remote server in a read-only fashion and
> will become read-write if the master is no longer available. The
> transition from RO to RW will involve a reboot of the server as there
> are lots of other things that need to be started with different
> properties as well.
Well, you could start off with PITR capabilities of 8.0. But you may need to
do quite a bit of customization and experimentation.
Check http://developer.postgresql.org/docs/postgres/backup-online.html
And we would be very eager to know your experience..:-)
HTH
Shridhar