Re: createdb confusion

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