Re: Yet Another Socket .s.PGSQL.5432 Problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Yet Another Socket .s.PGSQL.5432 Problem
Дата
Msg-id 7891.1187215277@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Yet Another Socket .s.PGSQL.5432 Problem  ("Hilton Perantunes" <hperantunes@gmail.com>)
Ответы Re: Yet Another Socket .s.PGSQL.5432 Problem
Список pgsql-admin
"Hilton Perantunes" <hperantunes@gmail.com> writes:
> When I stop the database, the socket file is automatically removed. That's
> the way it happened before... but now, oddly enough, I restarted the
> database at will several times, my app is still running, pgadmin too... and
> no socket file is created. o.0

Are you sure that's where the database thinks the socket file should be?
/var/run/postgresql is *not* the factory default for this; /tmp is.
If you replaced a distro build with your own or vice versa you may be
confused by that.

Wrong permissions on the directory or its parents could be the
problem, too.

> psql: could not connect to server:
> Is the server running locally and accepting
> connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?

This clip omits the most important part of the message: there should be
a kernel error code after the colon.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Hilton Perantunes"
Дата:
Сообщение: Re: Yet Another Socket .s.PGSQL.5432 Problem
Следующее
От: Julio Cesar Sánchez González
Дата:
Сообщение: Re: Configure pg_hba.conf