Re: createdb -- alternate locations

From: felix(at)crowfix(dot)com
To: pgsql-general(at)postgresql(dot)org
Cc: "J(dot)R(dot)" <jrbelding(at)yahoo(dot)com>
Subject: Re: createdb -- alternate locations
Date: 2000-05-26 18:16:30
Message-ID: 14638.49022.995240.335044@crowfix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry for the funky quoting, I read the digest and my mailer won't
burst it.

J.R. writes:
> ...
> 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"
> ...
> Any ideas what I'm doing wrong?

Yes, you need $PGDATA2 when referencing the env var for starters.

--
... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
Felix Finch: scarecrow repairman & rocket surgeon / felix(at)crowfix(dot)com
GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o

Browse pgsql-general by date

  From Date Subject
Next Message Pascal IMBERT 2000-05-26 18:33:07 Communication oracle-postgresql
Previous Message Barry Lind 2000-05-26 18:06:30 Re: Speed of locating tables?