[SOLVED] postgreSQL problems

skazhy · 2010-04-20 07:29:21

Hi!

I have some problems with postgreSQL. When I run /etc/rc.d/postgresql start it says server starting [DONE]. There is no postgresql process and when I run /etc/postgresql stop it says pg_ctl: PID file "var/lib/postgres/data/postmaster.pid" does not exist
Is server running? [FAIL]. I tried to run the postmaster, but it couldn't find data files.

How can I fix this?

Thanks in advance,

-skazhy

Last edited by skazhy (2010-04-21 05:27:46)

fukawi2 · 2010-04-20 09:01:31

What does /var/log/postgresql.log say?

skazhy · 2010-04-20 09:11:09

postgres cannot access the server configuration file "/var/lib/postgres/data/postgresql.conf": No such file or directory
postgres cannot access the server configuration file "/var/lib/postgres/data/postgresql.conf": No such file or directory
postgres cannot access the server configuration file "/var/lib/postgres/data/postgresql.conf": No such file or directory
postgres cannot access the server configuration file "/var/lib/postgres/data/postgresql.conf": No such file or directory
postgres cannot access the server configuration file "/var/lib/postgres/data/postgresql.conf": No such file or directory
postgres cannot access the server configuration file "/var/lib/postgres/data/postgresql.conf": No such file or directory
postgres cannot access the server configuration file "/var/lib/postgres/data/postgresql.conf": No such file or directory
postgres cannot access the server configuration file "/var/lib/postgres/data/postgresql.conf": No such file or directory
postgres cannot access the server configuration file "/var/lib/postgres/data/postgresql.conf": No such file or directory
FATAL:  data directory "/var/lib/postgres/data" has group or world access
DETAIL:  Permissions should be u=rwx (0700).

I copied .conf files to /var/lib/postgres/data but still, it cant found it. I changed permissions to 700 too, but it still doesnt work :(
FATAL:  data directory "/var/lib/postgres/data" has group or world access
DETAIL:  Permissions should be u=rwx (0700).
FATAL:  data directory "/var/lib/postgres/data" has group or world access
DETAIL:  Permissions should be u=rwx (0700).

fukawi2 · 2010-04-20 22:33:40

Try running:

su - postgresql
initdb -D /var/lib/postgres/data/

skazhy · 2010-04-21 05:27:26

thanks, fukawi2! now it works!

Arch Linux

#1 2010-04-20 07:29:21

[SOLVED] postgreSQL problems

#2 2010-04-20 09:01:31

Re: [SOLVED] postgreSQL problems

#3 2010-04-20 09:11:09

Re: [SOLVED] postgreSQL problems

#4 2010-04-20 22:33:40

Re: [SOLVED] postgreSQL problems

#5 2010-04-21 05:27:26

Re: [SOLVED] postgreSQL problems

Board footer