Thread: sysconfdir
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
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
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
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
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
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