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

Re: pg_config, pg_service.conf, postgresql.conf ....

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
Cc: Mark Woodward <pgsql(at)mohawksoft(dot)com>, Christopher Browne <cbbrowne(at)acm(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_config, pg_service.conf, postgresql.conf ....
Date: 2006-03-01 02:00:45
Message-ID: 4405004D.2050004@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers

Mark Kirkwood wrote:

>>
>>
>
> Do you need name, value pairs? I was thinking that something like:
>
> # Postgres Cluster Registration
> #
> # PG_HOME PGDATA PORT
> /usr/local/pg7.4.1   /vol01/pggeo      5435
> /usr/local/pg7.4.1   /vol01/pgicdmdb   5434
> /usr/local/pg7.4.1   /vol03/pg74       5432
>
>
> Clearly other fields are possible (like ALIAS for the names you were 
> using, and OPTS for extra arguments).
>
> This sort of layout is easily readable (more easily readable for those 
> of us used to standard UNIX config files) and simply parsable too.
>
>

I am a Unix guy through and through, but its config files have pained me 
many times over the years. Not least because of lack of consistency.

This sort of layout fails miserably if there are optional fields. Look 
at the handsprings we had to turn to put CIDR addresses into 
pg_hba.conf. And not without debate.

I don't much like ini style configs either.

These days, for Perl apps I generally make the config file a perl hash, 
which can be as deeply structured as you like. The great advantage is 
that you get parsing for free. For other apps I'm mildly inclined to 
YAML or XML configs. All of these might be verbose, but they have 2 huge 
advantages: they can adapt to structure, and they are somewhat 
self-documenting. I am currently wrestling with an app that does 
horrible things because its config needs to be tree structured and is 
instead flat  (and also utterly unreadable).

cheers

andrew

In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2006-03-01 02:01:22
Subject: Re: bug in 7.3.2
Previous:From: Mark WoodwardDate: 2006-03-01 01:03:05
Subject: Re: pg_config, pg_service.conf, postgresql.conf ....

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