Thread: Problem with starting my db with Postmaster

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

Thank you in advance
Toni

"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

does anyone know of an easy method of changing a msql db to a PgSQL db? I
found the MySQL to PgSQL converter ok, but an mSQL solution is out of my
grasp.
thanks in advance,

chris