Re: Recovery.conf and PITR

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Recovery.conf and PITR
Date: 2013-08-10 09:00:14
Message-ID: CAKoxK+5uf7O8BP3WGPZAMPimU_w607Wnv_-pasZoR-7GBivMCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

On Fri, Aug 9, 2013 at 2:17 PM, ascot(dot)moss(at)gmail(dot)com
<ascot(dot)moss(at)gmail(dot)com> wrote:

> Is there a way to query the master (it is up and running) about the actual commit sequence by transaction IDs?

The information is within the clogs, but nothing comes into my mind as
to inspect from an admin point of view the clog sequence.
Anyway, I suepect it is wrong the approach you have with recovery: you
are asking the database to recover at least up to transaction x, so
why worrying about other interleaved transactions?

Luca

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message karsten.lenz 2013-08-10 23:57:24 BUG #8380: initdb ignore options
Previous Message Jeff Janes 2013-08-09 18:53:36 Re: How to avoid Force Autovacuum

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2013-08-10 09:08:33 Re: earthdistance
Previous Message Chris Travers 2013-08-10 06:44:05 Re: How To Install Extension Via Script File?