Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A70C09F9A61 for ; Thu, 16 Aug 2007 18:11:30 -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 00386-03 for ; Thu, 16 Aug 2007 18:11:22 -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 040FA9F9E05 for ; Thu, 16 Aug 2007 18:11:24 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so123227waf for ; Thu, 16 Aug 2007 14:11:20 -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=YvXrZPovrldQKeDWtX1g9JblBW4Yx6dp5cIrsgmBHqjXLE0wTw/kmp4S4OkLcdWZOz8tcvUaa3QZv4Plwy+ZldP3jANR8xwh92Dl3kGuiI+ph8VI0SClRHY6JhyVW1tU43bqHG2j2vvZfi+h/BJQ/opHGdY2EA9TtTX0BXRiY70= 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=XVB7LlY5n6ea0eIJkDLVsWlzqkOGVb4SQlLPLGIzmJnfzkvlzqBeLuPlNNv0aXTWIyhFWaJJ8JJKIDIQ39bIQOxtXfH/KLwVo/Zigo8Rq0VnfKraqtO+hrPnpJ+GvrKiRr9zJ32Lo+ymimKBdud43Z6ErSBIRjxEQW9ySWtCLBM= Received: by 10.114.89.1 with SMTP id m1mr2410487wab.1187298680788; Thu, 16 Aug 2007 14:11:20 -0700 (PDT) Received: by 10.114.134.18 with HTTP; Thu, 16 Aug 2007 14:11:20 -0700 (PDT) Message-ID: Date: Thu, 16 Aug 2007 18:11:20 -0300 From: "Hilton Perantunes" To: pgsql-admin@postgresql.org Subject: Re: Yet Another Socket .s.PGSQL.5432 Problem In-Reply-To: <7891.1187215277@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_67292_31331795.1187298680726" References: <1187210085.6713.8.camel@andromeda> <7891.1187215277@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/197 X-Sequence-Number: 26528 ------=_Part_67292_31331795.1187298680726 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Tom, really... the socket lies in /tmp/. The socket file has 0777 postgres:postgres. /tmp/ has 0777 root:root. The socket file is removed when I stop the database. On 8/15/07, Tom Lane wrote: > > "Hilton Perantunes" writes: > > 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 > > Are you sure that's where the database thinks the socket file should be? > /var/run/postgresql is *not* the factory default for this; /tmp is. > If you replaced a distro build with your own or vice versa you may be > confused by that. > > Wrong permissions on the directory or its parents could be the > problem, too. > > > psql: could not connect to server: > > Is the server running locally and accepting > > connections on Unix domain socket > > "/var/run/postgresql/.s.PGSQL.5432"? > > This clip omits the most important part of the message: there should be > a kernel error code after the colon. > > regards, tom lane > --=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_67292_31331795.1187298680726 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Tom, really... the socket lies in /tmp/. The socket file has 0777 postgres:= postgres. /tmp/ has 0777 root:root.

The socket file is removed when = I stop the database.




On= 8/15/07,=20 Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Hilton Perantunes" <= hperantunes@gmail.com> writes:
> When I stop the database, the= socket file is automatically removed. That's
> the way it happen= ed before... but now, oddly enough, I restarted the
> database at will several times, my app is still running, pgadmin t= oo... and
> no socket file is created. o.0

Are you sure that&#= 39;s where the database thinks the socket file should be?
/var/run/postg= resql is *not* the factory default for this; /tmp is.
If you replaced a distro build with your own or vice versa you may beconfused by that.

Wrong permissions on the directory or its parent= s could be the
problem, too.

> psql: could not connect to serv= er:
> Is the server running locally and accepting
> connections on= Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?<= br>
This clip omits the most important part of the message: there should= be
a kernel error code after the colon.

    &nb= sp;            =        regards, tom lane



--
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 p= arecida...  -_- ------=_Part_67292_31331795.1187298680726--