Search Postgresql Archives

Re: SYSCONFDIR, initdb and postgresql.conf

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

 



On 2010-11-21, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> SYSCONFDIR is only used for global configuration files, like the default
> psqlrc or pg_service.conf.

OK, so it doesn't regard postgresql.conf and friends as conf files in
that sense.

> It would be pretty inappropriate to put postgresql.conf there
> because postgresql.conf is a per-cluster configuration file.

Debian does it with a hierarchy under /etc/postgres that reflects the
versions and clusters installed.  E.g. /etc/postgres/8.4/main holds
the cluster-conf files for the 'main' cluster running 8.4.

> 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.

It wants a '-o' to tell postgres where its config is.  Debian uses a
system of ingenious wrapper scripts that automatically set it.  My
poor man's version seems to be working in my /etc/rc.local,

     su -l _postgresql -c "nohup /usr/local/bin/pg_ctl start \
         -D /var/postgresql/9.0/main -l /var/postgresql/logfile \
         -o '-D /var/postgresql/9.0/main' \
         -o '-c config_file=/etc/postgresql/9.0/main/postgresql.conf' \
         >/dev/null"

> 			regards, tom lane

Thanks
-- 
KM

-- 
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