Re: PostgreSQL default data location

Found the problem,

It is a problem with the /etc/init.d/postgresql script.
On line 31 the script grabs the defaults from the
/etc/sysconfig/postgresql file which is where they should be. But then
on line 41-42 it goes to set these defaults by using the file
/etc/sysconfig/postgresql.d/${NAME} which would be the name of the
script running, fine if the script is /etc/init.d/postgresql. In the
case of going to run level 3 the file name is S85postgresql (a link to
/etc/init.d/postgresql)! Well there is no file with defaults named
/etc/sysconfig/postgresql.d/S85postgresql !!
Lines 40- 42 of this script should match the defaults from line 31 and
not reference the the name of the script being run. It should read:
# Override defaults from /etc/sysconfig/postgresql if file is present
[ -f /etc/sysconfig/postgresql ] && \
. /etc/sysconfig/postgresql

NOT as it does:
# Override defaults from /etc/sysconfig/postgresql if file is present
[ -f /etc/sysconfig/postgresql.d/${NAME} ] && \
. /etc/sysconfig/postgresql.d/${NAME}

James Herbers