Re: [GENERAL] Mirroring databases in v8

2004-10-06 Thread Glen Eustace
On Thu, 2004-10-07 at 03:06, Tom Lane wrote: > Not sure if you are familiar with the Slony project, but that is > probably your best bet for data propagation to a live slave at present Hi Tom, Thanks for the comment. I was aware of Slony but didn't want the mirroring to require addition of trigg

Re: [GENERAL] Mirroring databases in v8

2004-10-06 Thread Tom Lane
Glen Eustace <[EMAIL PROTECTED]> writes: > Having read this, it would seem I might be jumping the gun a bit. The > method given could be used to copy a running database to another system > but I'm not sure how it would work if the mirrored database is required > to be online at the same time. It

Re: [GENERAL] Mirroring databases in v8

2004-10-06 Thread Glen Eustace
On Wed, 2004-10-06 at 20:03, Shridhar Daithankar wrote: > 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 eage

Re: [GENERAL] Mirroring databases in v8

2004-10-06 Thread Shridhar Daithankar
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 data

[GENERAL] Mirroring databases in v8

2004-10-05 Thread Glen Eustace
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