Re: [HACKERS] Point in Time Recovery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Klaus Naumann <kn(at)mgnet(dot)de>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, 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 14:53:49
Message-ID: 8659.1090421629@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers pgsql-patches

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.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2004-07-21 20:00:49 Re: [HACKERS] Point in Time Recovery
Previous Message Peter Eisentraut 2004-07-21 10:13:30 Re: execute user-defined BKI

Browse pgsql-hackers by date

  From Date Subject
Next Message David F. Skoll 2004-07-21 14:59:28 Re: Patch for pg_dump: Multiple -t options and new -T
Previous Message Tom Lane 2004-07-21 14:39:47 Re: Patch for pg_dump: Multiple -t options and new -T option

Browse pgsql-patches by date

  From Date Subject
Next Message David F. Skoll 2004-07-21 14:59:28 Re: Patch for pg_dump: Multiple -t options and new -T
Previous Message Tom Lane 2004-07-21 14:39:47 Re: Patch for pg_dump: Multiple -t options and new -T option