Re: createdb -- alternate locations - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: createdb -- alternate locations
Date
Msg-id Pine.GSO.4.02A.10005261358570.12244-100000@Falk.DoCS.UU.SE
Whole thread Raw
In response to createdb -- alternate locations  ("J.R." <jrbelding@yahoo.com>)
List pgsql-general
On Thu, 25 May 2000, J.R. wrote:

> mkdir /home/postgres/testdata
> export PGDATA2=/home/postgres/testdata
> initlocation PGDATA2
> createdb testdb -D 'PGDATA2'

You need to set the PGDATA2 environment variable in the environment of the
postmaster. That is, shut it down, export xxx, restart. Not ideal, I know,
but we're working on it.

>
> the last command failed with this error:
> "The database path 'PGDATA2' in invalid.  This may be due to a character
> that is not allowed or because the chosen path isn't permitted for
> databases"


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-general by date:

Previous
From: Michael Blakeley
Date:
Subject: group by week (ww), plus -S performance
Next
From: Shaw Terwilliger
Date:
Subject: Re: What distribution?