Re: Mirroring databases in v8

Glen Eustace <geustace(at)godzone(dot)net(dot)nz> 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 wouldn't. You can have a "hot spare" database via log shipping, but
there is zero chance of allowing the backup to run any independent
transactions. (If it did, its xact counter and pg_clog would get out of
sync with the master, causing all subsequently copied data to be
invalid. AFAICS, even read-only transactions would be problematic.)

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.

regards, tom lane