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(dot)Elphick(at)lfix(dot)co(dot)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