Problem with starting my db with Postmaster

Started by Toni Pljakoskiabout 25 years ago3 messagesgeneral
Jump to latest
#1Toni Pljakoski
pgtoni@yahoo.com

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

#2Oliver Elphick
olly@lfix.co.uk
In reply to: Toni Pljakoski (#1)
Re: Problem with starting my db with Postmaster

"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

#3Chris Hayner
hayner80@astro.ocis.temple.edu
In reply to: Oliver Elphick (#2)
mSQL to PgSQL

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