Re: database location problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Devinder K Rajput" <Devinder(dot)Rajput(at)ipaper(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: database location problems
Date: 2002-12-05 19:21:13
Message-ID: 29884.1039116073@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Devinder K Rajput" <Devinder(dot)Rajput(at)ipaper(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Mark Wilson 2002-12-05 19:35:01 Infinite Loop
Previous Message Kelly McDonald 2002-12-05 19:20:54 Test to see if currval will fail?