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

From: Stefan Schwarzer <stefan(dot)schwarzer(at)unep(dot)org>
To: pgsql-general(at)postgresql(dot)org
Cc: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Subject: Re: Error message "psql: could not connect to server: No such file or directory"
Date: 2012-06-22 07:19:36
Message-ID: F192F32B-ED01-4CCF-9F90-9A77165E5A17@unep.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> sudo su - _postgres /usr/local/pgsql-9.1/bin/initdb -U postgres -D /usr/local/pgsql-9.1/data --encoding=UTF8 --locale=en_US
> sudo su - _postgres /usr/local/pgsql-9.1/bin/pg_ctl start -D /usr/local/pgsql-9.1/data
>
> Although I don't get an error message, I don't have the feeling that it started the server. There is still nothing in the process list, and a normal "psql" results in the same message as before "psql: could not connect…"
>
> So sorry for bothering you guys… just being really frustrated now…
>
> If you have any ideas, please let me know… :-)

I just went back to the postgres documentation [1] (actually reading all google results on the error message one after the other) and tried out what was said there (adapted to my conditions):

sudo -u _postgres /usr/local/pgsql-9.1/bin/postgres -D /usr/local/pgsql-9.1/data

and suddenly postgres runs….

[1] http://www.postgresql.org/docs/9.1/static/server-start.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Schwarzer 2012-06-22 07:19:52 Re: Problem installing extensions on Lion
Previous Message Stefan Schwarzer 2012-06-22 06:49:02 Re: Error message "psql: could not connect to server: No such file or directory"