From: | mlw <pgsql(at)mohawksoft(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org, pgsql-patches-owner(at)postgresql(dot)org |
Subject: | new Configuration patch, implements 'include' |
Date: | 2003-02-17 17:54:33 |
Message-ID: | 3E5121D9.3070100@mohawksoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This is a patch that allows PostgreSQL to use a configuration
file that is outside the main database directory.
It adds one more command line parameter, "-C" which
specifies the location of the postgres configuration file.
A patched version of PostgreSQL will function as:
postmaster -C /etc/postgres/postgresql.conf
This will direct the postmaster program to use the
configuration file "/etc/postgres/postgresql.conf"
Within this file are four additional parameters: include,
hba_conf,ident_conf, and data_dir.
They are used as:
include = '/etc/postgres/debug.conf'
data_dir = '/vol01/postgres'
hba_conf = '/etc/postgres/pg_hba_conf'
ident_conf = '/etc/postgres/pg_ident.conf'
The "-D" option on the command line overrides the "data_dir"
in the configuration file.
If no hba_conf and/or ident_conf setting is specified, the default
$PGDATA/pg_hba.conf and/or $PGDATA/pg_ident.conf will be used.
This patch is intended to move the PostgreSQL configuration out of the
data directory so that it can be modified and backed up.
This patch is also useful for running multiple servers with the same
parameters:
postmaster -C /etc/postgres/postgresql.conf -D /VOL01/postgres -p 5432
postmaster -C /etc/postgres/postgresql.conf -D /VOL02/postgres -p 5433
To apply the patch, enter your PostreSQL source directory, and run:
cat pgec-PGVERSON.patch | patch -p 1
Attachment | Content-Type | Size |
---|---|---|
pgec-7.3.2.patch | text/plain | 12.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-02-17 18:39:07 | Re: location of the configuration files |
Previous Message | Tom Lane | 2003-02-17 16:24:41 | Re: client_encoding directive is ignored in |