Incrementally Updated Backups - Mailing list pgsql-general

From Gabe Nell
Subject Incrementally Updated Backups
Date
Msg-id AANLkTinLLTPTpEi4BY1LH-sFMQahFkMUK--Us81+zg=A@mail.gmail.com
Whole thread Raw
Responses Re: Incrementally Updated Backups  (Bruce Momjian <bruce@momjian.us>)
Re: Incrementally Updated Backups  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-general
Hello,

I'm interested in the "incrementally updated backups" scenario
described in section 25.6 of the Postgres 9 documentation. I've
configured streaming replication for my warm standby server.

Step 2 in this procedure is to note pg_last_xlog_replay_location at
the end of the backup. However it seems like this requires hot standby
to be configured; otherwise there is no way of connecting to the
standby machine to make the required query. That does not seem clear
from the documentation. Is there a way to get this without using hot
standby?

Thanks

Gabe

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: SQL Programming Question
Next
From: Bruce Momjian
Date:
Subject: Re: Incrementally Updated Backups