Re: [HACKERS] Point in Time Recovery - Mailing list pgsql-patches

From Tom Lane
Subject Re: [HACKERS] Point in Time Recovery
Date
Msg-id 8659.1090421629@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Point in Time Recovery  (Klaus Naumann <kn@mgnet.de>)
Responses Re: [HACKERS] Point in Time Recovery  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-patches
Klaus Naumann <kn@mgnet.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.

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patch for pg_dump: Multiple -t options and new -T option
Next
From: "David F. Skoll"
Date:
Subject: Re: Patch for pg_dump: Multiple -t options and new -T