Re: Please help On Alternative Database Location

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