Configure redux. "WITH LOCATION," what do you think?

From: pgsql(at)mohawksoft(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: Configure redux. "WITH LOCATION," what do you think?
Date: 2004-05-11 19:05:42
Message-ID: 16744.24.91.171.78.1084302342.squirrel@mail.mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm sorry to keep bringing this up, but I keep thinking that PostgreSQL is
a PITA to configure. It isn't that I don't know how, or can't read the
documents, it's just that there is too many things that can go wrong or
leave me with the "How does that work?" feeling where I need to test
before I implement.

OK, here is what I think we need to do, and I am willing to take the point
and do all of it:

If postmaster is started with -D or with $PGDATA set to the location of a
postgresql cluster directory, it will work as it has always worked.

If the -D or the $PGDATA values do not point to a database cluster
directory, it must point to either a postgresql.conf file, or a directory
which contains "postgresql.conf." If it points to a directory, then that
directory will be the assumed the default for pg_hba.conf and
pg_ident.conf.

The test for it being a cluster directory or a configuration directory
will be the presence of "PG_VERSION." (any better suggestion would be
welcome

Within the postgresql.conf file, there will be about 4 additional
configuration parameters:

include='/somepath/coreopts.conf'
hba_conf='/somepath/pg_hba.conf'
ident_conf='somepath/pg_ident.conf'
pgdata='/somepath/to/cluster'

(Unfortunately we lose the ability to use a standard configuration across
multiple databases, but I think this is a good compromise.)

Additionally, rather than depend on environment variables for security, we
can put acceptable database locations in the postgresql.conf file in the
form of:

altdb='/somealtpath'

and we can use createdb as:

CREATE DATABASE somedb with LOCATION 'altdb';

What do you all think?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Hallgren 2004-05-11 19:06:00 Module dependency on PostgeSQL version
Previous Message Thomas Hallgren 2004-05-11 18:06:49 Re: Advice regarding configuration parameters