Re: database location problems - Mailing list pgsql-novice

From Tom Lane
Subject Re: database location problems
Date
Msg-id 29884.1039116073@sss.pgh.pa.us
Whole thread Raw
In response to database location problems  ("Devinder K Rajput" <Devinder.Rajput@ipaper.com>)
List pgsql-novice
"Devinder K Rajput" <Devinder.Rajput@ipaper.com> writes:
> 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).

You have not mentioned the step where you start the postmaster --- but
you need to make sure you give that same -D switch to the postmaster.

            regards, tom lane

pgsql-novice by date:

Previous
From: Kelly McDonald
Date:
Subject: Test to see if currval will fail?
Next
From: "Mark Wilson"
Date:
Subject: Infinite Loop