Re: [ADMIN] Cannot install postgreSQL - Mailing list pgsql-admin

From Oliver Elphick
Subject Re: [ADMIN] Cannot install postgreSQL
Date
Msg-id 200003071911.TAA06936@linda.lfix.co.uk
Whole thread Raw
In response to Cannot install postgreSQL  (Roman Kurmanowytsch <romank@infosys.tuwien.ac.at>)
Responses Re: [ADMIN] Cannot install postgreSQL
List pgsql-admin
Roman Kurmanowytsch wrote:
  >Seems OK to me, but when I run postgres (after starting the ipc daemon) with
      >:
  >postgres.exe -i
  >I get the following error-message:
  >
  ><OUTPUT>
  >FATAL 1:  Database romkur does not exist in pg_database
  >FATAL 1:  Database romkur does not exist in pg_database
  ></OUTPUT>
  >

There is no database called "romkur", because you haven't yet created it.

When initdb is run, it creates a database called template1; this is the
only database that exists until you create some more.

When you try to connect as a database user, postgres assumes you want
your eponymous database, unless you tell it different.  So tell it
you want to connect to template1.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Go ye therefore, and teach all nations, baptizing them
      in the name of the Father, and of the Son, and of the
      Holy Ghost; Teaching them to observe all things
      whatsoever I have commanded you; and, lo, I am with
      you alway, even unto the end of the world. Amen."
                     Matthew 28:19,20



pgsql-admin by date:

Previous
From: Ruben Fagundo
Date:
Subject: Database Import
Next
From: Roman Kurmanowytsch
Date:
Subject: Re: [ADMIN] Cannot install postgreSQL