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

From felix@crowfix.com
Subject Re: createdb -- alternate locations
Date
Msg-id 14638.49022.995240.335044@crowfix.com
Whole thread Raw
In response to createdb -- alternate locations  ("Richard J. Kuhns" <rjk@grauel.com>)
List 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@crowfix.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

pgsql-general by date:

Previous
From: Jeff Hoffmann
Date:
Subject: Re: Rollover of tables?
Next
From: Pascal IMBERT
Date:
Subject: Communication oracle-postgresql