Re: createdb -- alternate locations

From: Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE>
To: "J(dot)R(dot)" <jrbelding(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: createdb -- alternate locations
Date: 2000-05-26 12:00:16
Message-ID: Pine.GSO.4.02A.10005261358570.12244-100000@Falk.DoCS.UU.SE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Barnes 2000-05-26 12:11:51 Windoze port of version 7
Previous Message Alfred Perlstein 2000-05-26 10:41:07 Re: PG 7.0 is 2.5 times slower running a big report