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