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

Re: Proposal for Allow postgresql.conf values to be changed via SQL

From: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
To: "'Fujii Masao'" <masao(dot)fujii(at)gmail(dot)com>
Cc: <cedric(at)2ndquadrant(dot)com>, <pgsql-hackers(at)postgresql(dot)org>, "'Robert Haas'"<robertmhaas(at)gmail(dot)com>, "'Greg Smith'" <greg(at)2ndquadrant(dot)com>, "'Josh Berkus'"<josh(at)agliodbs(dot)com>, "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Magnus Hagander'"<magnus(at)hagander(dot)net>, "'Christopher Browne'" <cbbrowne(at)gmail(dot)com>
Subject: Re: Proposal for Allow postgresql.conf values to be changed via SQL
Date: 2012-11-19 05:38:32
Message-ID: 006801cdc618$1ddb2bb0$59918310$@kapila@huawei.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> On Sunday, November 18, 2012 3:08 AM Fujii Masao wrote:
> On Sat, Nov 17, 2012 at 10:25 PM, Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
> wrote:
> > 1. have a system table pg_global_system_settings(key,value)
> 
> Do we really need to store the settings in a system table?
> Since WAL would be generated when storing the settings
> in a system table, this approach seems to prevent us from
> changing the settings in the standby.

Thanks for your feedback.

  It is one of the Approach, we were trying to evaluate for this feature.
  However this feature can be done by directly operating on file as well.

With Regards,
Amit Kapila.



In response to

pgsql-hackers by date

Next:From: JiangGuiqingDate: 2012-11-19 06:03:31
Subject: [PATCH] Patch to fix missing libecpg_compat.lib and libpgtypes.lib.
Previous:From: Tomas VondraDate: 2012-11-19 01:56:29
Subject: Re: pg_trgm partial-match

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