On Tue, September 25, 2007 3:34 am, Ow Mun Heng wrote:
Hi guys,
need some clarification on whether there is a config file sourced by the init script to determine where PGDATA is located.
Right now, it seems like it's not sourced from anywhere by located on the init file itself.
Appreciate if you guys can let me know if this is the correct place for altering it.
Multiple instances of Postgres database will have separate init scripts. The location of the config file for each init script is
/etc/sysconfig/pgsql/<init-script-name>
For example, for the default init script (/etc/init.d/postgresql) that gets installed with Postgres, the config file is /etc/sysconfig/pgsql/postgresql . Although the /etc/sysconfig/pgsql directory gets created when Postgres is installed, you will not find any config files in it initially. In order to change the default PGDATA (and/or PGPORT) values, you sill need to create appropriately named config file that will look like this:
PGDATA=/data/pg PGPORT=3456
You don't need to set both values in it if you are changing only one default value.
I hope this helps.
Marko