[CentOS] Postgres Config File (eg: PGDATA)
Ow Mun Heng
Ow.Mun.Heng at wdc.comThu Oct 4 07:29:58 UTC 2007
- Previous message: [CentOS] automounted filesystem appears empty on first reference
- Next message: [CentOS] Problems suspending/hibernating Dell Latitude D810 with CentOS 5
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Tue, 2007-09-25 at 04:18 -0400, Marko A. Jennings wrote: > 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 > Missed the below in the 1st glance. Thanks for the pointer and sorry for the lateness. I only re-started to look at this again now. (My test bed was my laptop running gentoo) # Override defaults from /etc/sysconfig/pgsql if file is present [ -f /etc/sysconfig/pgsql/${NAME} ] && . /etc/sysconfig/pgsql/${NAME} export PGDATA export PGPORT
- Previous message: [CentOS] automounted filesystem appears empty on first reference
- Next message: [CentOS] Problems suspending/hibernating Dell Latitude D810 with CentOS 5
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the CentOS mailing list