Re: PostgreSQL configuration - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: PostgreSQL configuration
Date
Msg-id 200404121455.i3CEtdT17825@candle.pha.pa.us
Whole thread Raw
In response to Re: PostgreSQL configuration  ("Thomas Swan" <tswan@idigx.com>)
Responses Re: PostgreSQL configuration
List pgsql-hackers
Thomas Swan wrote:
> I thought the idea was to *reduce* the number of config files and provide
> a unified configuration file.  Ideally, the unified configuration file
> could eliminate the need for environment variables altogether.
> 
> If I understand this correctly, the author was adding the ability to do
> this, not remove the default behavior.
> 
> A single configuration point (which can be changed with a commandline
> switch) with the ability to include would be an exceptionally versatile
> asset for postgresql.  Maybe relocating PID would be a bad idea and
> someone could clobber their database, but that could be addressed with
> LARGE WARNING in that config file where the option is available.
> 
> Outside of the unified config file argument.   "Configuration includes"
> give postgresql the ability to have shared settings.  You could have a
> shared pg_hba.conf and test all other manner of settings with a set of
> config files (sort_mem, shared_buffers, etc.) that say include a
> standard_pg_hba.conf to control access.

I suggested a new pg_path configuration file because it would enable
centralized config only if it was used.  By adding /data location to
postgresql.conf, you have the postgresql.conf file acting sometimes via
PGDATA and sometimes as a central config file, and I thought that was
confusing.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: "Thomas Swan"
Date:
Subject: Re: PostgreSQL configuration
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL configuration