Обсуждение: Crazy hard time getting up and running
Anyone know how to get around this one:
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
On 08/05/2013 09:55 AM, Kinnard Hockenhull wrote: > Anyone know how to get around this one: > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"? > > -- > All the best, > Kinnard Hockenhull > Founder + CEO, > BitBox <http://bitbox.mx/> Well, Is the server really running ? Is it running locally or remotely ?
"Is the server really running ? Is it running locally or remotely ?"
It was running locally.
It was running locally.
turns out I needed to modify postgresql.conf
I needed to uncomment 'listenaddresses' and 'port'
I couldn't find postgresql.conf
Why would these be commented out by default?
On Mon, Aug 5, 2013 at 1:00 AM, Tovo Rabemanantsoa <tovo.rabemanantsoa@bordeaux.inra.fr> wrote:
> BitBox <http://bitbox.mx/>On 08/05/2013 09:55 AM, Kinnard Hockenhull wrote:
> Anyone know how to get around this one:
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
>
> --
> All the best,
> Kinnard Hockenhull
> Founder + CEO,
Well,
Is the server really running ? Is it running locally or remotely ?
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
On 08/05/2013 10:49 AM, Kinnard Hockenhull wrote: > "Is the server really running ? Is it running locally or remotely ?" > It was running locally. > turns out I needed to modify postgresql.conf > I needed to uncomment 'listenaddresses' and 'port' > I couldn't find postgresql.conf > > > Why would these be commented out by default? I suppose that they are commented to ensure that admin reads the conf file and customize it. So, if it runs, and assuming that your're running a linux box, do you have the process running (listed by ps) ? What about the result of netstat -l ?