Re: createdb confusion - Mailing list pgsql-general

From Mike Mascari
Subject Re: createdb confusion
Date
Msg-id 3B71DDF4.7B023458@mascari.com
Whole thread Raw
In response to createdb confusion  (newsreader@mediaone.net)
Responses Re: createdb confusion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: newsreader@mediaone.net
Date:
Subject: Re: createdb confusion
Next
From: Mike Mascari
Date:
Subject: Re: createdb confusion