Re: Alternate database locations

On Tue, 19 Feb 2002, Jokerman wrote:

> i think you should create the database using 'initdb /opt/paislay'.
> then you can add the PGDATA2 variable on your environment.

  I thought of this, too. I created a directory called
/opt/paisley/acctdata/, gave it permissions of 700, changed the owner.group
to postgres.postgres, then ran initdb specifying that directory. It worked
just fine.

  Next I changed the environment variable, PGDATA2, to
/opt/paisley/acctdata/ in postgres's and my ~/.bash_profile, restarted the
postmaster and got the same error message: createdb failed because the
postmaster doesn't understand PGDATA2.

  Now I'll try it again without quotes on the path.

Thanks,

Rich