Обсуждение: Problem/Question

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

Can you help????  Need more info???

__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com

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