pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Julio Cesar Sánchez González <knowhow@sistemasyconectividad.com.mx>
To: Hilton Perantunes <hperantunes@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Yet Another Socket .s.PGSQL.5432 Problem
Date: Wed, 15 Aug 2007 15:34:44 -0500
Message-ID: <1187210085.6713.8.camel@andromeda> (raw)
In-Reply-To: <b24a8cca0708151313k43c05849y8906967046775a2b@mail.gmail.com>
References: <b24a8cca0708151313k43c05849y8906967046775a2b@mail.gmail.com>

El mié, 15-08-2007 a las 17:13 -0300, Hilton Perantunes escribió:
> Hi folks!
> 
> That's another "sob sob.. I can't connect to socket blah
> blah .. .s.PGSQL.5432" asking for help. But this is somewhat bizarre,
> and i'm not used to the 8.2's postgresql.conf file.
> 
> I'm running a PostgreSQL 8.4.2 powered by Debian Sarge (very)Unstable.
> My PHP application successfully connects to the appropriated database.
> Even PgAdmin3 connects to the database. But my 'postgres' user cannot
> connect to the database via command line: 
> 
> ----------
> psql: could not connect to server:
>         Is the server running locally and accepting
>         connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?
> ----------
> 
> Well, the socket file actually IS there (zero bytes of size) and it's
> given the correct permissions. Now, I have this in my pg_hba.conf
> (replace XXX by my network, and I just added the second line recently,
> in despair): 
> 

Try stoping the postgresql process and delete the socket unix file,
restart the postgresql daemon and we to mean.

> ----------
> # "local" is for Unix domain socket connections only
> local   all         all                               trust
> # IPv4 local connections:
> host    all         all         XXX.XXX.XXX.1 /24       trust
> host    all         postgres    127.0.0.1/32          trust
> # IPv6 local connections:
> host    all         all         ::1/128               trust
> ----------
> 
> Finally, that's the hot section in my postgresql.conf:
> 
> ----------
> listen_addresses = '*'                  # what IP address(es) to
> listen on;  
> port = 5432                             # (change requires restart) 
> ----------
> 
> So, I just can't connect in the database through command line. Someone
> can waste some time helping me?
> 
> Thanks in advance =)
> 
> -- 
> Hilton William Ganzo Perantunes
> Sistemas de Informação - Universidade Federal de Santa Catarina 
> --
> Dinheiro não traz felicidade, mas dá uma sensação tão parecida...  -_-



-- 
Regards,

Julio Cesar Sánchez González
www.sistemasyconectividad.com.mx
blog: http://darkavngr.blogspot.com

---
Ahora me he convertido en la muerte, destructora de mundos.
Soy la Muerte que se lleva todo, la fuente de las cosas que vendran.




view thread (10+ messages)  latest in thread

Message-ID: <1187210085.6713.8.camel@andromeda>
Permalink:  ../1187210085.6713.8.camel@andromeda/
Also on:    postgresql.org/message-id/1187210085.6713.8.camel@andromeda

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: knowhow@sistemasyconectividad.com.mx, hperantunes@gmail.com
  Subject: Re: Yet Another Socket .s.PGSQL.5432 Problem
  In-Reply-To: <1187210085.6713.8.camel@andromeda>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox