Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F1A259F9E05 for ; Thu, 16 Aug 2007 18:42:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 01055-04 for ; Thu, 16 Aug 2007 18:42:01 -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.177]) by postgresql.org (Postfix) with ESMTP id 9CA099F9C3C for ; Thu, 16 Aug 2007 18:42:00 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so7425waf for ; Thu, 16 Aug 2007 14:41:59 -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=qVQgSNB6X36BOlD2tlI20NINlRSH3QT+GZVddrtt13nOHnby826J6qUWyPU8ue5/cH7Srn3twzGByfAsJDMNEEdT+JCcnV4/vpSUE726OL0FteLzBS4vtk20ilSEht1RAL18MCwK6GeqfamFy5THjRszrXRWBykr17WaeOHhKEg= 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=iZvNCFFOW+0qbwWeAeUVPmxL9sOEaHRXP5PQVC8BccxXSab5eOhDHUgEA+ca9gja2FzeJ7XMq+t9GXMJ+98XYVL2EOmIWscEsHqprtzfnG1jvjEcpBCgZIQNX9tcveGXVsPr8M2aapvX6uXZ+Z3JtC0bD6DZz3UscXIwL9T6n60= Received: by 10.114.193.1 with SMTP id q1mr747574waf.1187300518943; Thu, 16 Aug 2007 14:41:58 -0700 (PDT) Received: by 10.114.134.18 with HTTP; Thu, 16 Aug 2007 14:41:58 -0700 (PDT) Message-ID: Date: Thu, 16 Aug 2007 18:41:58 -0300 From: "Hilton Perantunes" To: pgsql-admin@postgresql.org Subject: Re: Yet Another Socket .s.PGSQL.5432 Problem In-Reply-To: <20070816212517.GC27775@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_67572_27736296.1187300518901" References: <1187210085.6713.8.camel@andromeda> <7891.1187215277@sss.pgh.pa.us> <20070816212517.GC27775@alvh.no-ip.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/199 X-Sequence-Number: 26530 ------=_Part_67572_27736296.1187300518901 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Alvaro, it works like a charm =3D). Thank you all. Bad, bad Debian.. no cookies for you (and I'll read the error messages more carefully next time)! Abra=E7os.. Hilton Perantunes On 8/16/07, Alvaro Herrera wrote: > > Hilton Perantunes escribi=F3: > > Tom, really... the socket lies in /tmp/. The socket file has 0777 > > postgres:postgres. /tmp/ has 0777 root:root. > > psql is complaining about /var/run/postgresql (the Debian packaging of > libpq does that). Try setting PGHOST to /tmp, like in > > PGHOST=3D/tmp psql > > > -- > Alvaro Herrera Developer, > http://www.PostgreSQL.org/ > "The eagle never lost so much time, as > when he submitted to learn of the crow." (William Blake) > --=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_67572_27736296.1187300518901 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Alvaro, it works like a charm =3D). Thank you all.

Bad, bad Debian.= . no cookies for you (and I'll read the error messages more carefully n= ext time)!

Abra=E7os..

Hilton Perantunes



= On 8/16/07, Alvaro Herrera <alvherre@commandprompt.com> wrot= e:
Hilton Perantunes escribi=F3:
> Tom, really... the socket lies in /tm= p/. The socket file has 0777
> postgres:postgres. /tmp/ has 0777 root= :root.

psql is complaining about /var/run/postgresql (the Debian pac= kaging of
libpq does that).  Try setting PGHOST to /tmp, like in
PGHOST=3D/tmp psql


--
Alvaro Herrera    =             &nb= sp;         Developer, http://www.PostgreSQL.org/
"The eagle never lost so much time, as
when he submitted to learn o= f the crow." (William Blake)



--
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_67572_27736296.1187300518901--