newsreader@mediaone.net wrote:
>
...
> > I try (as postgres user)
> >
> > $ createdb -D /bla bla
> >
> > and it says
> >
> > absolute path are not allowed.
> >
> > Then I read man initlocation. The example
> > I see is
> >
> > $ initlocation /opt/postgres/data
> > $ createdb -D /opt/postgres/data/testdb testdb
> >
> > so I do the same and it fails with the same reason
> >
> > Does anyone have any idea?
How about:
export PGDATA2=/opt/postgres/data
initlocation PGDATA2
createdb -D PGDATA2 mydb
I haven't created databases in alternate locations, so I'm just
going by the manual. ;-)
Mike Mascari
mascarm@mascari.com