| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Judy Jecelin <jjecelin(at)yahoo(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Problem/Question |
| Date: | 2002-02-21 23:01:52 |
| Message-ID: | 20020221150012.U23226-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2002-02-21 23:22:31 | Re: Building binary... |
| Previous Message | Stephan Szabo | 2002-02-21 22:59:24 | Re: Set Passsword for existing User |