postgres user can connect but no one else

Поиск
Список
Период
Сортировка
От A B
Тема postgres user can connect but no one else
Дата
Msg-id dbbf25900811030204y784693bj658d2a9510f5ef1@mail.gmail.com
обсуждение исходный текст
Ответы Re: postgres user can connect but no one else  ("Obe, Regina" <robe.dnd@cityofboston.gov>)
Re: postgres user can connect but no one else  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
I can do

# su - postgres
$ psql

and run sql commands, but  running
 psql
as the user I just created with the command

createuser -s -d -E -P -e myself

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

I run psql as the "myself" user. and even psql -U myself template1
fails.  (template1 was the database that always is there, right?)

pg_hba.conf says

local   all         all                              trust
host    all         all         127.0.0.1/32          password
host    all         all         ::1/128               password

I'm not sure why I cant connect.

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

Предыдущее
От: Marcin Krol
Дата:
Сообщение: the cost of logging statements
Следующее
От: "Obe, Regina"
Дата:
Сообщение: Re: postgres user can connect but no one else