From: | "Devinder K Rajput" <Devinder(dot)Rajput(at)ipaper(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | database location problems |
Date: | 2002-12-05 00:32:25 |
Message-ID: | OF3D998D59.770F665E-ON86256C86.00019D25@ipaper.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | hodges | 2002-12-05 03:29:07 | pg_hba.conf file |
Previous Message | Ron Johnson | 2002-12-05 00:22:02 | Re: Yet one more stupid question |