Re: [HACKERS] Point in Time Recovery

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Klaus Naumann <kn(at)mgnet(dot)de>, markw(at)osdl(dot)org, pgman(at)candle(dot)pha(dot)pa(dot)us, pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] Point in Time Recovery
Date: 2004-07-21 20:00:49
Message-ID: 1090439667.2658.1260.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers pgsql-patches

On Wed, 2004-07-21 at 15:53, Tom Lane wrote:
> Klaus Naumann <kn(at)mgnet(dot)de> writes:
> > Simon doesn't mean the recovery part. Instead he means the "normal"
> > startup of the server. It has to be absolutely clear (in the logfile!) if
> > the server was started in archive mode or not. Otherwise you always have
> > to guess.
>
> Why would you guess? "SHOW archive_command" will tell you, without
> question, at any time. I don't see the point of placing such a message
> in the postmaster log --- in normal circumstances the postmaster will
> still be running long after its starting messages have been discarded
> due to log rotation.
>
> Also, the current implementation allows you to stop and start archiving
> on-the-fly, so a start-time message would be an unreliable guide to what
> the postmaster is actually doing at the moment.
>

Overall, this is a small point and I think we should leave Tom alone, to
focus on the bigger issues that we care about.

Tom has done an amazingly good job in the last few days of refactoring
some reasonably ugly code on my part, all without a murmur. I relent on
this to allow everything to be finished in time.

The PITR journey has just begun, so there will be further opportunity to
discuss and agree what constitutes real issues and then correct them.
This may not be on that list later.

Best Regards, Simon Riggs

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Si Chen 2004-07-21 20:04:02 How to identify the transaction of a lock?
Previous Message Tom Lane 2004-07-21 14:53:49 Re: [HACKERS] Point in Time Recovery

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2004-07-21 20:47:07 Re: parameter hints to the optimizer
Previous Message Simon Riggs 2004-07-21 20:00:48 PreallocXlogFiles

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-07-21 20:18:12 Re: autovacuum integration attempt #3
Previous Message Andrew Dunstan 2004-07-21 19:04:06 Re: pg_config