Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8368B9F990B for ; Wed, 15 Aug 2007 17:49:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 07424-10 for ; Wed, 15 Aug 2007 17:48:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.182]) by postgresql.org (Postfix) with ESMTP id D43BD9F9884 for ; Wed, 15 Aug 2007 17:48:59 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id k40so44641wah for ; Wed, 15 Aug 2007 13:48:58 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=W7TRwybb6Mo1mrA0t86zYTxIZaUEaTQzKYtKsUlO6ckQHk1pz83wwJOT/J9upU3nud+yMqtz4FE4r6T54MembBFRlmO248dEkHg4xRA1nWuQNCdbLra+bRXSnNIs/aeC1tRg0Zpq3luW7yI3n9MxbFHaxvc8RWaFNqmrnc1DfV8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=XI+dxlLJhr+vL8o2ilPIQnkZBnUflzkIj/ok78UAdxJr6gT//VFjbrStmmXxfGBicK2QpehF6mD4D0dLXYw6TJUXAkg7OWxkTwLAPGtZadW10uMsD2W2qmpb4D+nPq/1SDo2iFEKjEWGpaia8KXL4O3v5t60/M69n9owAX9Z2Nc= Received: by 10.115.54.1 with SMTP id g1mr1011871wak.1187210937669; Wed, 15 Aug 2007 13:48:57 -0700 (PDT) Received: by 10.114.134.18 with HTTP; Wed, 15 Aug 2007 13:48:57 -0700 (PDT) Message-ID: Date: Wed, 15 Aug 2007 17:48:57 -0300 From: "Hilton Perantunes" To: pgsql-admin@postgresql.org Subject: Re: Yet Another Socket .s.PGSQL.5432 Problem In-Reply-To: <1187210085.6713.8.camel@andromeda> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_51334_5506100.1187210937619" References: <1187210085.6713.8.camel@andromeda> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.623 tagged_above=0 required=5 tests=AWL=0.278, BAYES_20=-0.74, HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001, URIBL_RHS_DOB=1.083 X-Spam-Level: X-Archive-Number: 200708/190 X-Sequence-Number: 26521 ------=_Part_51334_5506100.1187210937619 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thanks for answering, Julio. When I stop the database, the socket file is automatically removed. That's the way it happened before... but now, oddly enough, I restarted the database at will several times, my app is still running, pgadmin too... and no socket file is created. o.0 (and I still can't connect via bash) Hilton On 8/15/07, Julio Cesar S=E1nchez Gonz=E1lez < knowhow@sistemasyconectividad.com.mx> wrote: > > El mi=E9, 15-08-2007 a las 17:13 -0300, Hilton Perantunes escribi=F3: > > 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 =3D '*' # what IP address(es) to > > listen on; > > port =3D 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 =3D) > > > > -- > > Hilton William Ganzo Perantunes > > Sistemas de Informa=E7=E3o - Universidade Federal de Santa Catarina > > -- > > Dinheiro n=E3o traz felicidade, mas d=E1 uma sensa=E7=E3o t=E3o parecid= a... -_- > > > > -- > Regards, > > Julio Cesar S=E1nchez Gonz=E1lez > 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. > > --=20 Hilton William Ganzo Perantunes Sistemas de Informa=E7=E3o - Universidade Federal de Santa Catarina -- Dinheiro n=E3o traz felicidade, mas d=E1 uma sensa=E7=E3o t=E3o parecida...= -_- ------=_Part_51334_5506100.1187210937619 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thanks for answering, Julio.

When I stop the database, the socket fi= le is automatically removed. That's the way it happened before... but n= ow, oddly enough, I restarted the database at will several times, my app is= still running, pgadmin too... and no socket file is created.=20 o.0

(and I still can't connect via bash)

Hilton


On 8/15/07, Julio Cesar S=E1nchez Gonz=E1lez < knowhow@sistemasyconectividad.com.mx> wrote:
El mi=E9, 15-08-2007 a las 17:13 -= 0300, Hilton Perantunes escribi=F3:
> Hi folks!
>
> That's another "sob sob.. I can= 't connect to socket blah
> blah .. .s.PGSQL.5432" asking fo= r help. But this is somewhat bizarre,
> and i'm not used to the= =20 8.2's postgresql.conf file.
>
> I'm running a PostgreSQ= L 8.4.2 powered by Debian Sarge (very)Unstable.
> My PHP application = successfully connects to the appropriated database.
> Even PgAdmin3 c= onnects to the database. But my 'postgres' user cannot
> connect to the database via command line:
>
> --------= --
> psql: could not connect to server:
>   &nbs= p;     Is the server running locally and accepting
&= gt;         connections on Unix dom= ain socket
> "/var/run/postgresql/.s.PGSQL.5432"?
> ----------<= br>>
> Well, the socket file actually IS there (zero bytes of size= ) and it's
> given the correct permissions. Now, I have this in m= y pg_hba.conf
> (replace XXX by my network, and I just added the second line recen= tly,
> in despair):
>

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

> ----------
> # "local" is for Unix domain sock= et connections only
> local   all    &n= bsp;    all        &= nbsp;           &nbs= p;          trust
> # IP= v4 local connections:
> host    all  &n= bsp;      all      &= nbsp; =20 XXX.XXX.XXX.1 /24       trust
> host&nb= sp;   all         po= stgres    127.0.0.1/32<= /a>          trust
>= ; # IPv6 local connections:
> host    all &n= bsp;       all     &= nbsp;   ::1/128        &n= bsp;      trust
> ----------
>
> Finally, that's the hot section in = my postgresql.conf:
>
> ----------
> listen_addresses =3D= '*'          &nb= sp;       # what IP address(es) to
&g= t; listen on;
> port =3D 5432         = ;            &n= bsp;       # (change requires restart)
>= ; ----------
>
> So, I just can't connect in the database t= hrough command line. Someone
> can waste some time helping me?
>
> Thanks in advance =3D)
>
> --
> Hilton W= illiam Ganzo Perantunes
> Sistemas de Informa=E7=E3o - Universidade F= ederal de Santa Catarina
> --
> Dinheiro n=E3o traz felicidade,= mas d=E1 uma sensa=E7=E3o t=E3o parecida...  -_-



--
Regards,

Julio Cesar S=E1nchez Gonz=E1lez
<= a href=3D"http://www.sistemasyconectividad.com.mx">www.sistemasyconectivida= d.com.mx

blog: http://dark= avngr.blogspot.com

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




--
Hilton William = Ganzo Perantunes
Sistemas de Informa=E7=E3o - Universidade Federal de Santa Catarina
= --
Dinheiro n=E3o traz felicidade, mas d=E1 uma sensa=E7=E3o t=E3o parec= ida...  -_- ------=_Part_51334_5506100.1187210937619--