Arch Linux

_adam_

Member

From: Dora, Alabama

Registered: 2006-05-18

Posts: 94

PostgreSQL doesnt start. [solved]

When attemtping to start Postgres using "/etc/rc.d/postgresql start" i get this output:

:: Starting PostgreSQL                                                           [BUSY] 
could not change directory to "/home/adam"
postmaster starting                           
                                                                                  [DONE]

The directory that it tries to change to is whatever the pwd is at the time.

When pwd is "/var/lib/postgres" which is Postgres' home directory, it retunrs this result:

:: Starting PostgreSQL                                                           [BUSY] 
postmaster starting
                                                                                 [DONE]

but postgresql is still not started. "ps ax | grep postgresql" returns nothing.

Is there some config i have to set first?

afu

Member

From: Tuscalooser, Alabummer

Registered: 2004-02-19

Posts: 155

Re: PostgreSQL doesnt start. [solved]

There is some issues like configuration but I cannot recall because it has been a while. Check the Arch WIKI first. If that does not help:

Here is the short version from the postgres documentation using native commands:
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

Maybe this will help.
-Shawn

_adam_

Member

From: Dora, Alabama

Registered: 2006-05-18

Posts: 94

Re: PostgreSQL doesnt start. [solved]

ahhh....i had to initialize the db. thanks for the help.