Skip site navigation (1) Skip section navigation (2)

Re: Streaming Replication docs

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Streaming Replication docs
Date: 2010-02-13 18:17:15
Message-ID: 407d949e1002131017u657e4aefo2647c2cbf24fe7b4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
On Fri, Feb 12, 2010 at 9:14 AM, Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
> One glaring issue with the current documentation layout is that the
> documentation for the various options in recovery.conf is split in two
> places.

I've been trying to explain to someone how to set this all up and they
keep asking me why there's a separate recovery.conf file. I thought it
made sense back when it was to control PITR and was a transient file
which only applied as long as it was recovering but it seems now to
have become part of the normal setup of the server.

It seems like it would be much easier to keep things straight if you
could set up the master and all the slaves identically and they would
know when they had to store or retrieve files from the WAL archive and
when they had to make or listen for streaming connections based on
their master/slave status -- which is the only bit which needs to be
stored outside the configuration so it can be changed dynamically.

The master/slave status would be indicated by a trigger file or some
external master election daemon connecting and issuing a query calling
a magic sql function.

But having the separate recovery.conf seems kind of pointless legacy
structure at this point.
-- 
greg

In response to

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2010-02-14 00:56:19
Subject: CREATE FUNCTION reference page's Notes section is getting out of hand
Previous:From: Joshua D. DrakeDate: 2010-02-12 18:26:38
Subject: Re: Streaming Replication docs

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-02-13 18:28:48
Subject: Re: knngist patch support
Previous:From: Teodor SigaevDate: 2010-02-13 18:13:19
Subject: Re: knngist patch support

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group