Search Postgresql Archives

Re: initdb $PGDATA not working

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

 



On 02/09/12 1:25 PM, Daniel Vázquez wrote:
I've set my PGDATA variable in profile
export PGDATA=/home/mydata/pgsql/data

Testing variable for correct set in enviroment
$ echo $PGDATA
/home/mydata/pgsql/data

but when execute:
$ sudo /etc/init.d/postgresql-9.1 initdb

or execute:
$ sudo /etc/init.d/postgresql-9.1 initdb -D /home/mydata/pgsql/data

The cluster always is created on default path "/var/lib/pgsql/9.1/data/"

Will install in CentOS 5.7

the /etc/init.d/postgresql* scripts are completely selfcontained and don't use any external environment variables. you can put custom settings in /etc/sysconfig/pgsql/postgresql-9.1 (where the last part of the filename is the same as the /etc/init.d/ script name). the main things you'd set in those scripts are...

   PGENGINE=/usr/pgsql-${PGMAJORVERSION}/bin
   PGPORT=5432
   PGDATA=/var/lib/pgsql/${PGMAJORVERSION}/data
   PGLOG=/var/lib/pgsql/${PGMAJORVERSION}/pgstartup.log


However, if you're creating a cluster under your own home directory, I'm not sure you even want it to be under the control of the system scripts.

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast



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