Re: Continuous On-line Backups

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Cc: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
Subject: Re: Continuous On-line Backups
Date: 2006-03-24 23:19:52
Message-ID: 200603250019.53577.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-03-24 23:41:58 Re: OT: using column in an interval
Previous Message Stephan Szabo 2006-03-24 22:09:55 Re: OT: using column in an interval