Problem/Question

From: Judy Jecelin <jjecelin(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem/Question
Date: 2002-02-20 18:06:05
Message-ID: 20020220180605.76687.qmail@web12805.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Naomi Walker 2002-02-20 18:46:32 Postgres Log Rolling
Previous Message Gaetano Mendola 2002-02-20 17:50:55 Re: Postgresql 7.2 on Red-hat 7.1