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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
