Thread: Please help On Alternative Database Location

it's sure that this email should to be write to
anywhere but here, but the various requests to help
done in some mailings lists about postgresqk are
failed.So i write you, in the hope to receive an
response.
Briefly the question.
I work under Linux platform, Mandrake 7.2
distribution, and i need to create a postgres
database, for example called "mydb", in alternative
location, for example "/home/username". In the
official documentation this is very simple to do, but
in the reality i have failed.
This is my steps
1) su - username
2) set PGDATA2 = "/home/username" (but i tried
relatives path too)
3) initlocation $PGDATA2
4) createdb -D $PGDATA2 mydb

Finally an error message appears like this
"The database path '/home/username' is invalid. This
may be due to a character that is not allowed or
because the chosen path isn't permitted for databases"


I tried the relatives paths "~" and "." too, but the
message is the same.
Please help me
I like to know the right procedure step by step
Thanck you so much


__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/

Francesco Protano <fprotano@yahoo.com> writes:
> I work under Linux platform, Mandrake 7.2
> distribution, and i need to create a postgres
> database, for example called "mydb", in alternative
> location, for example "/home/username". In the
> official documentation this is very simple to do, but
> in the reality i have failed.
> This is my steps
> 1) su - username
> 2) set PGDATA2 = "/home/username" (but i tried
> relatives path too)
> 3) initlocation $PGDATA2
> 4) createdb -D $PGDATA2 mydb

The environment variable PGDATA2 needs to be present in the postmaster's
environment, not only the client's.  Also, leave off the $ in steps 3
and 4; you are trying to pass the name of the environment variable to
the postmaster, not its value.

            regards, tom lane

Francesco Protano writes:

> 1) su - username
> 2) set PGDATA2 = "/home/username" (but i tried
> relatives path too)
> 3) initlocation $PGDATA2
> 4) createdb -D $PGDATA2 mydb

initlocation PGDATA2
createdb -D PGDATA2 mydb

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/