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

Re: Explicit config patch 7.2B4

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Explicit config patch 7.2B4
Date: 2001-12-17 17:08:59
Message-ID: 1008608940.2013.0.camel@linda (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Mon, 2001-12-17 at 12:22, mlw wrote:
> > That's been Mark's primary argument all along, and what it ignores is
> > that the standard behavior for daemons is designed around the assumption
> > that a system is running only one copy of any given daemon.  That's a
> > fine assumption for most daemons but an unacceptable one for Postgres.
> It makes NO such argument at all! It allows an admin to explicitly share a
> configuration file (or not). I allows for one central place in which multiple
> configuration files can be stored and backed up. It allows for the explicit
> sharing of pg_hba.conf files. (It was noted that pg_ident.conf should be added,
> I am looking at it.)
> Most of all it does these things WITHOUT symlinks. Most admins I know like
> symlinks as a method of working around a short coming in a product, but would
> rather have the configurability designed into the product.
> I wrote this patch to make it easier for me to administer multiple databases on
> one machine. To make it easier for UNIX admins to follow the dba's trail. I
> wrote this so a system was a bit more self documenting without having to follow
> symlinks.

As Debian packager I would very much like to see a more convenient and
controllable configuration system.

Ross described last week the Debian method of symlinking the real config
files in /etc/postgresql to $PGDATA/; this method is forced on us by
Debian policy, which requires that all config files be in /etc.  The
undesired result is that it is not convenient to run multiple servers on
a single machine using the Debian package.

I am currently considering a method of getting round this by creating a
subdirectory of /etc/postgresql for each server instance, but it would
be nice to be able to share global options in more convenient ways than
by multiplying symlinks.  

Oliver Elphick                                Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight                    
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "For I say, through the grace given unto me, to every 
      man that is among you: Do not think of yourself more 
      highly than you ought, but rather think of yourself 
      with sober judgement, in accordance with the measure 
      of faith God has given you."            Romans 12:3 

In response to

pgsql-hackers by date

Next:From: Lamar OwenDate: 2001-12-17 17:30:14
Subject: Re: Explicit config patch 7.2B4
Previous:From: Hannu KrosingDate: 2001-12-17 16:57:03
Subject: Re: 7.2 is slow?

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