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?
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 &
Maybe this will help.
ahhh....i had to initialize the db. thanks for the help.