database location problems

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

Responses

Browse pgsql-novice by date

  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