>> I would like to store the data in a directory such as /www/db >> which would require me to tell the postmaster process on >> startup to use the directive -D /www/db. Since this is all >> automated, how do I go about doing that? And is the -I option >> superfluous since it is started in runtime 3,5? Thanks for the >> help!! > > The script /etc/init.d/postgresql reads a configuration file at > /etc/sysconfig/pgsql/postgresql. To setup a custom path, you set > the values for PGDATA, PGPORT, and PGOPTS. That being said, I > would again advise you to stick with the default paths. >
Yes, use default paths. It is completely unnecessary and a bad idea to make the data files within a web accessible directory. Warren
