Error message "psql: could not connect to server: No such file or directory"

Поиск
Список
Период
Сортировка
От Stefan Schwarzer
Тема Error message "psql: could not connect to server: No such file or directory"
Дата
Msg-id 356A36A0-945E-4D0A-A2C8-3930F29BEDDC@unep.org
обсуждение исходный текст
Ответы Re: Error message "psql: could not connect to server: No such file or directory"  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
Hi there,

I guess this is a typical user error. I searched around to find the solution, but in vain.

I just upgraded to Lion, and used Kyngchaos libraries for installation of Postgres.

Try to get running postgres, and I get this:

      /usr/local/pgsql-9.1/bin/psql -U postgres
      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"?


In my limited understanding, it seems that Postgres is not running. When I use:

       ps auxw | grep post

out comes only the "grep post", but no postgres process.

When I use:

       sudo launchctl load /Library/LaunchDaemons/org.postgresql.postgres.plist

it says:

       org.postgresql.postgres: Already loaded

and displays in the "ps" list then:

       user        935   0.0  0.1  2493888   7296   ??  Ss    3:24PM   0:00.12
/System/Library/PrivateFrameworks/DiskImages.framework/Resources/diskimages-helper-uuid
9EFB9424-7971-4A8B-9D73-B93BD7F1DB5F-post-exec 4 

(which looks a bit strange to me (DiskImages ??))


I am somewhat lost (and worse is that it worked the other day, before re-installing Lion anew.).

Thanks for any hints,

Stef

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

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: about seperate users in PostgreSQL
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Problem installing extensions on Lion