From: Hilton Perantunes <hperantunes@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Yet Another Socket .s.PGSQL.5432 Problem
Date: Fri, 17 Aug 2007 08:28:27 -0300
Message-ID: <b24a8cca0708170428x2545e0fevb8e84e57509b71c6@mail.gmail.com> (raw)
In-Reply-To: <200708171109.25370.peter_e@gmx.net>
References: <b24a8cca0708151313k43c05849y8906967046775a2b@mail.gmail.com>
<20070816212517.GC27775@alvh.no-ip.org>
<b24a8cca0708161441y1fee6786r55ba2290faa2c35@mail.gmail.com>
<200708171109.25370.peter_e@gmx.net>
Exactly what happened, Peter. Something was preventing me of successfully
install 8.2.4 through apt-get, so I did it by hand.
I'll read the documentation about LD_LIBRARY_PATH.
Thank you.
Hilton Perantunes
On 8/17/07, Peter Eisentraut <peter_e@gmx.net> wrote:
>
> Am Donnerstag, 16. August 2007 23:41 schrieb Hilton Perantunes:
> > Alvaro, it works like a charm =). Thank you all.
> >
> > Bad, bad Debian.. no cookies for you (and I'll read the error messages
> more
> > carefully next time)!
>
> The problem is quite likely some variant on the following: You had your
> distribution-supplied PostgreSQL packages installed, which
> use /var/run/postgresql as the socket location. Then you built your own
> pieces of PostgreSQL, which use /tmp. When you call just "psql"
> or "pgadmin3", they will use the system-supplied libpq, which uses the
> system-specific socket location, since they don't know about your
> hand-crafted installation. If you had called the psql binary from your
> own
> installation with an explicit path (and your used the rpath feature during
> compilation), then this would have worked. Or you could have used the
> environment variable LD_LIBRARY_PATH to point to the libpq of your choice.
> There are a few ways to get this wrong. On Debian the socket location is
> usually the first indicator, but you ought to be careful in general if you
> mix installations like that.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
--
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... -_-
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: hperantunes@gmail.com
Subject: Re: Yet Another Socket .s.PGSQL.5432 Problem
In-Reply-To: <b24a8cca0708170428x2545e0fevb8e84e57509b71c6@mail.gmail.com>
* 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