Re: Problem with starting my db with Postmaster - Mailing list pgsql-general

From Oliver Elphick
Subject Re: Problem with starting my db with Postmaster
Date
Msg-id 200101182109.f0IL9Nq31478@linda.lfix.co.uk
Whole thread Raw
In response to Problem with starting my db with Postmaster  ("Toni Pljakoski" <pgtoni@yahoo.com>)
Responses mSQL to PgSQL  (Chris Hayner <hayner80@astro.ocis.temple.edu>)
List pgsql-general
"Toni Pljakoski" wrote:
  >Hi
  >when I run
  >
  >postmaster -D /home/mydb
  >
  >I get an error
  >
  >[4850] Fatal 1 Database "/home/mydb" does not exist in the system catalog
  >
  >What could be the problem?
  >I ran initdb and it didnt show any problems

Databases's have names that are internal to PostgreSQL; they are not
file system paths.

Become the user that ran initdb (usually postgres) and do:

$ createuser your-unix-user-name

give yourself database creation privilege.  Then, become your-unix-user-name
again and:

$ createdb mydb
$ psql mydb
--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "For the eyes of the LORD run to and fro throughout the
      whole earth, to show himself strong in the behalf of
      them whose heart is perfect toward him..."
                                   II Chronicles 16:9



pgsql-general by date:

Previous
From: "Adam Lang"
Date:
Subject: Re: MS Access data to PostgrSQL data
Next
From: Lamar Owen
Date:
Subject: Re: Troubles with performances