Hi,
I have installed 7.3 in /usr/local/pgsql. However, I want the system
tables, config files, etc. located in the /data/db/system directory. I am
able to do "initdb -D PGDATA" (PGDATA = /data/db/system) and it works fine.
However, when I try to create a database, createdb tells me that it cannot
find /usr/local/pgsql/data/global/1262 (which i assume is template1).
However, I can do an initdb with PGDATA set to /usr/local/pgsql/data and
then I am able to create databases, but this is not what I need.
I also tried setting the datadir=/data/db/system before running
./configure. However, this creates a postgresql directory under
/data/db/system and puts sample files there. And when I go to do an initdb
with PGDATA set to /data/db/system, it complains that the directory is not
empty.
short version:
I need:
installation dir: /usr/local/pgsql
system tables, config files, etc.: /data/db/system
databases
/data/db/<dbname>
Can anybody please show me the light, so to speak. Thank you,
Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474