On Wed, 20 Feb 2002, Judy Jecelin wrote:
>
> Hi,
>
> I'm at my wits end with this one.
>
> I'm using PostgreSQL 7.1.3 on Solaris 2.8.
> I want to create two databases in the same
> postmaster. I did my initdb and started
> the postmaster. I set two environment
> variables, one for each database's location.
> Next:
>
> initlocation -D DB1
> initlocation -D DB2
>
> createuser DB1
> createuser DB2
>
> createdb -U DB1 -D DB1
> createdb -U DB2 -D DB2
>
> The first createdb works fine, the second:
> ERROR: CREATE DATABSAE: database "postgres" already
> exists
> createdb: database creation failed
You aren't making different database names with those
createdbs. I'd guess you probably wanted:
createdb -U DB1 -D DB1 DB1
createdb -U DB2 -D DB2 DB2