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/