Problem/Question - Mailing list pgsql-admin

From Judy Jecelin
Subject Problem/Question
Date
Msg-id 20020220180605.76687.qmail@web12805.mail.yahoo.com
Whole thread Raw
Responses Re: Problem/Question  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Andrey Romanchenko
Date:
Subject: Re: psql error
Next
From: Bruce Momjian
Date:
Subject: Re: FATAL 1: configuration file 'postgresql.conf' has wrong