Postgres Pro
Downloads
Home   >   mailing lists

Thread: Cannot create database

Cannot create database

From
Domagoj Cajic
Date:
First i want to say that i just subscribed to this mailing list and this
is my first post. :)

im new to postgresql and i installed it recently on linux redhat 9
system following the instructions from administrators tutorial.

then i attempted to create "my first database" following the
instructions from tutorial, but i get this message:

[root@localhost root]# createdb mydb
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
createdb: database creation failed

can someone help me? whats wrong? i am logged in as root, just started
learning postgresql...

Re: Cannot create database

From
darren@crystalballinc.com
Date:
Have you started the database server (postmaster)??

Try in the bin directory looking for pg_ctl bin and issuing pg_ctl start.

This will start the db server (postmaster) then you should be able to
issue the createdb command

HTH
Darren



On 5 Oct 2003, Domagoj Cajic wrote:

> First i want to say that i just subscribed to this mailing list and this
> is my first post. :)
>
> im new to postgresql and i installed it recently on linux redhat 9
> system following the instructions from administrators tutorial.
>
> then i attempted to create "my first database" following the
> instructions from tutorial, but i get this message:
>
> [root@localhost root]# createdb mydb
> psql: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> createdb: database creation failed
>
> can someone help me? whats wrong? i am logged in as root, just started
> learning postgresql...
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
Darren Ferguson

Re: Cannot create database

From
Peter Eisentraut
Date:
Domagoj Cajic writes:

> then i attempted to create "my first database" following the
> instructions from tutorial, but i get this message:
>
> [root@localhost root]# createdb mydb
> psql: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> createdb: database creation failed

You did not start the database server.

--
Peter Eisentraut   peter_e@gmx.net

Re: Cannot create database

From
"scott.marlowe"
Date:
On 5 Oct 2003, Domagoj Cajic wrote:

> First i want to say that i just subscribed to this mailing list and this
> is my first post. :)
>
> im new to postgresql and i installed it recently on linux redhat 9
> system following the instructions from administrators tutorial.
>
> then i attempted to create "my first database" following the
> instructions from tutorial, but i get this message:
>
> [root@localhost root]# createdb mydb
> psql: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> createdb: database creation failed
>
> can someone help me? whats wrong? i am logged in as root, just started
> learning postgresql...

I'm not sure which instructions you've followed.  Somewhere along the
line, the instructions should have included creating a superuser account
named postgresq, or something similar, setting the $PGDATA env var,
running initdb, then running pg_ctl start.

Or did you install from .rpm files?

Either way, you should not be interfacing with the database as root (or
doing anything else you don't NEED to be root to do.)  It's a bad habit to
be root when you don't need to be on a unix box.