pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Klaus Naumann <kn@mgnet.de>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: markw@osdl.org
Cc: pgman@candle.pha.pa.us
Cc: pgsql-patches@postgresql.org
Subject: Re: [HACKERS] Point in Time Recovery
Date: Wed, 21 Jul 2004 10:53:49 -0400
Message-ID: <8659.1090421629@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.58.0407210946170.930@spock.intra.net>
References: <200407201536.i6KFa7122392@mail.osdl.org>
	<Pine.LNX.4.58.0407201825340.930@spock.intra.net>
	<1090344478.3377.8.camel@stromboli>
	<4589.1090388994@sss.pgh.pa.us>
	<Pine.LNX.4.58.0407210946170.930@spock.intra.net>

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



view thread (111+ messages)  latest in thread

Message-ID: <8659.1090421629@sss.pgh.pa.us>
Permalink:  ../8659.1090421629@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/8659.1090421629@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, kn@mgnet.de, simon@2ndquadrant.com, markw@osdl.org, pgman@candle.pha.pa.us, pgsql-patches@postgresql.org
  Subject: Re: [HACKERS] Point in Time Recovery
  In-Reply-To: <8659.1090421629@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox