Re: Continuous On-line Backups

Thomas F. O'Connell wrote:
> So long as I know that nothing will access the recovery database with
> write activity, is there a way to toggle the continuity so that I
> could allow recovery to complete on a nightly basis, pg_dump the
> recovered database (a read-only action), and then resume recovering?

Even a read-only action uses up transaction numbers and other things, so
I'd expect that to be a problem.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/