createdb -- alternate locations

From: "J(dot)R(dot)" <jrbelding(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: createdb -- alternate locations
Date: 2000-05-26 02:26:46
Message-ID: 392DE0E6.1DC80659@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello:

Novice, just installed PGSQL 7.0 on Redhat 6.1.

Everything went smoothly with initial installation and db setup.
However, I've run into some problems subsequently.

To keep it simple, here is a specific problem. Attempting to create a
database in an alternate location, I went through the following steps as
the superuser (postgres):

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

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"

I also tried createdb -D 'PGDATA2' testdb, same result.

Any ideas what I'm doing wrong?

Thanks,
J.R. Belding
jrbelding(at)yahoo(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Tassell 2000-05-26 02:51:37 Re: createdb -- alternate locations
Previous Message Marcin Inkielman 2000-05-26 00:06:07 Re: PG 7.0 vacuum problem