Thread: sysconfdir

sysconfdir

From
brichardson@lineone.net (Bruce Richardson)
Date:
Is there any way to tell where postgres is looking for it's config file,
or to tell it where to look?  I compiled the 7.1RC4 source tarball with
--prefix=/usr/local (and using stow to keep things tidy in /usr/local)
but it is entirely ignoring the postgresql.conf and pg_hba.conf files.

--
Bruce

Anyone who slaps a 'this page is best viewed with Browser X' label on a
Web page appears to be yearning for the bad old days, before the Web...
        -- Tim Berners-Lee

Re: sysconfdir

From
Peter Eisentraut
Date:
Bruce Richardson writes:

> Is there any way to tell where postgres is looking for it's config file,
> or to tell it where to look?  I compiled the 7.1RC4 source tarball with
> --prefix=/usr/local (and using stow to keep things tidy in /usr/local)
> but it is entirely ignoring the postgresql.conf and pg_hba.conf files.

These files live in the data directory ($PGDATA), where initdb puts them.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


Re: sysconfdir

From
Lamar Owen
Date:
Peter Eisentraut wrote:
> Bruce Richardson writes:
> > Is there any way to tell where postgres is looking for it's config file,
> > or to tell it where to look?  I compiled the 7.1RC4 source tarball with
> > --prefix=/usr/local (and using stow to keep things tidy in /usr/local)
> > but it is entirely ignoring the postgresql.conf and pg_hba.conf files.

> These files live in the data directory ($PGDATA), where initdb puts them.

I would like to see an option for putting the conf files under a
directory in /etc at some point, with the ability to have more than one
installation available, as well.  That is one thing I am going to try to
get done during the 7.2 dev cycle -- RPM support for multiple databases
with tools to manage them.

And that would be an option, and could easily default to off, BTW.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Re: sysconfdir

From
Peter Eisentraut
Date:
Lamar Owen writes:

> I would like to see an option for putting the conf files under a
> directory in /etc at some point, with the ability to have more than one
> installation available, as well.

You mean a "master" configuration file that is read first and sets the
defaults for the "local" configuration files?  That seems doable.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


Re: sysconfdir

From
Bruce Richardson
Date:
On 4/23/01, 3:57:34 PM, Lamar Owen <lamar.owen@wgcr.org> wrote regarding
Re: [GENERAL] sysconfdir:

> > These files live in the data directory ($PGDATA), where initdb puts
them.

> I would like to see an option for putting the conf files under a
> directory in /etc at some point, with the ability to have more than
one
> installation available, as well.  That is one thing I am going to try
to
> get done during the 7.2 dev cycle -- RPM support for multiple
databases
> with tools to manage them.

Have the config files always lived in PGDATA or was that a new feature
of 7.1?  I always used the Debian packages till now but switched to
the source tarballs for 7.1 because I couldn't get the Debian packages
to install.

--

Bruce




Re: sysconfdir

From
Bruce Richardson
Date:
On 4/23/01, 5:27:07 PM, Bruce Richardson <pgsql@itsbruce.uklinux.net>
wrote regarding Re: [GENERAL] sysconfdir:
> Have the config files always lived in PGDATA or was that a new feature
> of 7.1?  I always used the Debian packages till now but switched to
> the source tarballs for 7.1 because I couldn't get the Debian packages
> to install.

And (I forgot to say) the Debian config files were in /etc/postgres

--

Bruce