> Try createdb -D $PGDATA2 testdb
I will be surprised if that works. The initlocation manual says -D can
be a path or an environment variable which will be referenced. Not sure
what that means.
>
> At 11:26 PM 5/25/00, J.R. wrote:
> > 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@yahoo.com
> >
> >
> >
>
>
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026