Re: Continuous On-line Backups - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Continuous On-line Backups
Date
Msg-id 200603250019.53577.peter_e@gmx.net
Whole thread Raw
In response to Continuous On-line Backups  ("Thomas F. O'Connell" <tfo@sitening.com>)
Responses Re: Continuous On-line Backups
List pgsql-admin
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/

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: OT: using column in an interval
Next
From: Tom Lane
Date:
Subject: Re: OT: using column in an interval