Geek asks and answers

Problems connecting psql

I installed postgresql according to the instructions given at: http://xadmin.info/?p=284

# pg_ctl -D /var/lib/pgsql/data -l pglog.log start
server starting
postgres@linux-p0pl:~> psql
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"?

I do not understand why I get this error when starting the server ... maybe someone please, please help.

The following output is displayed in my pglog.log file:

2013-02-06 19:43:39 GMT   FATAL:  lock file "postmaster.pid" already exists
2013-02-06 19:43:39 GMT   HINT:  Is another postmaster (PID 23971) running in data directory "/var/lib/pgsql/data"?
2013-02-06 19:44:02 GMT   FATAL:  lock file "postmaster.pid" already exists
2013-02-06 19:44:02 GMT   HINT:  Is another postmaster (PID 23971) running in data directory "/var/lib/pgsql/data"?
2013-04-24 12:43:29 GMT   FATAL:  data directory "/var/lib/pgsql/data" has group or world access
2013-04-24 12:43:29 GMT   DETAIL:  Permissions should be u=rwx (0700).
2013-04-24 12:44:07 GMT   FATAL:  data directory "/var/lib/pgsql/data" has group or world access
2013-04-24 12:44:07 GMT   DETAIL:  Permissions should be u=rwx (0700).
2013-04-24 12:57:02 GMT   FATAL:  data directory "/var/lib/pgsql/data" has group or world access
2013-04-24 12:57:02 GMT   DETAIL:  Permissions should be u=rwx (0700).
2013-04-24 12:57:40 GMT   FATAL:  data directory "/var/lib/pgsql/data" has group or world access
2013-04-24 12:57:40 GMT   DETAIL:  Permissions should be u=rwx (0700).

ps -ef | grep postgres

root     21659 21591  0 19:14 pts/0    00:00:00 grep --color=auto postgres
+5
source share
3 answers

Permits and ownership /var/lib/pgsql/datamust be:

# ll -d /var/lib/pgsql/data
drwx------. 15 postgres postgres 4096 Apr 24 10:27 /var/lib/pgsql/data

If they are not running as root:

# chmod -R 700 /var/lib/pgsql/data
# chown -R postgres /var/lib/pgsql/data
+13
source

Check the file pglog.logto make sure that the server is really running without errors. Given the mistake, it seems that it did not start properly.

+1
source

, unix "/tmp". , - "/var/run/pgsql", postgresql.conf, , .

"" :

psql -h /path/we/want ...

If this is not a problem, check the port number.

I don’t know why / how your psql client and postgresql server have different default paths, but then I never heard about which one you received the instructions on, so I don’t know how useful they are.

+1
source

More articles:


All Articles