Fwd: Re: database location problems

Hi !

-D is for for your preferred location, that is, ih this case, your 'custom'
datadir.

But why ? What is wrong with default values ? Defaults work fine on any
'default box', and you do not have to recall all different set-ups ? Lot's of
remembering / documentation skipped. We want to standardize a good thing ?

Other issues like security, access control and such forth can be configured by
firewalls ( I have three + plus the system ) and config files etc. ?

This is just my view ...

Very best regards and take care !

t: a

----------  Forwarded Message  ----------

Subject: Re: [NOVICE] database location problems
Date: Thu, 05 Dec 2002 14:21:13 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Devinder K Rajput" <Devinder.Rajput@ipaper.com>
Cc: pgsql-novice@postgresql.org

"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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-------------------------------------------------------