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