Search Postgresql Archives

Re: SYSCONFDIR, initdb and postgresql.conf

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



KM <km@xxxxxxxxxxxxx> writes:
> On an OpenBSD machine I just compiled and installed 9.0.1.  The
> ./configure arguments included '--sysconfdir=/etc'.  Running
> 'pg_config --sysconfdir' returns '/etc/postgresql'.  The cluster is
> running and I can create a database and connect to it.

> However, initdb put the config files in the directory named by the
> --pgdata option.  There is no directory /etc/postgresql.

> Should I expect this?  How do I persuade postgres to put its config
> under /etc?

SYSCONFDIR is only used for global configuration files, like the default
psqlrc or pg_service.conf.  It would be pretty inappropriate to put
postgresql.conf there because postgresql.conf is a per-cluster
configuration file.

Having said that, you don't have to put postgresql.conf in the data
directory if you don't want to.  Just move it to where you do want it
(along with the other cluster config files) and add an entry to it to
point to the actual data directory.  Beware that this arrangement isn't
supported as fully as the default --- in particular, I think pg_ctl
will have some trouble with it.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux