Re: unite recovery.conf and postgresql.conf - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: unite recovery.conf and postgresql.conf
Date
Msg-id 1316175187.14316.1.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to Re: unite recovery.conf and postgresql.conf  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: unite recovery.conf and postgresql.conf
List pgsql-hackers
On fre, 2011-09-16 at 01:32 -0400, Tom Lane wrote:
> As far as the other issues go, I think there is actually a
> prerequisite
> discussion to be had here, which is whether we are turning the
> recovery
> parameters into plain old GUCs or not.  If they are plain old GUCs,
> then
> they will presumably still have their values when we are *not* doing
> recovery.  That leads to a couple of questions:
> * will seeing these values present in pg_settings confuse anybody?

How so?  We add or change the available parameters all the time.

> * can the values be changed when not in recovery, if so what happens,
>   and again will that confuse anybody?

Should be similar to archive_command and archive_mode.  You can still
see and change archive_command when archive_mode is off.

> * is there any security hazard from ordinary users being able to see
>   what settings had been used? 

Again, not much different from the archive_* settings.  They are, after
all, almost the same in the opposite direction.




pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Double sorting split patch
Next
From: Peter Eisentraut
Date:
Subject: Re: unite recovery.conf and postgresql.conf