Re: On Ubuntu 12.04 i do have two psql one of those isn't working

From: Yvon Thoraval <yvon(dot)thoraval(at)gmail(dot)com>
To: rod(at)iol(dot)ie
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: On Ubuntu 12.04 i do have two psql one of those isn't working
Date: 2012-09-17 11:52:23
Message-ID: CAG6bkBx4W73gyG+AuKROSQhLBCpRpSQKouoFB6Dsaa-S_RmFUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2012/9/17 Raymond O'Donnell <rod(at)iol(dot)ie>

>
> The first isn't a "real" psql - it's a symlink to pg_wrapper, which is
> how Debian and Ubuntu allow you to run different Postgres versions and
> clusters on the same machine. You call the client program (psql,
> pg_dump, etc) you want as usual, but pass it the --cluster option, as
> follows:
>
> psql --cluster 9.1/main (....)
>
> and then pg_wrapper calls the correct version of the client program.
>
>
OK, thanks very much, I'll try that ASAP.

> >
> > then, i wonder how to workaround this "installation bugg" because i
> > suspect php is using the second not working psql where the first is the
> > one being in my PATH.
>
> PHP doesn't use psql, it uses libpq (the client library).
>

then, the php link to the client library is faulty.

I've to find why.
surprisingly, when from a php script i want to connect to another pgsql
server, on another machine, by it's IPV6 addresse it works as expected...

--
Yvon

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-09-17 11:58:55 Re: foreign key from array element
Previous Message Yvon Thoraval 2012-09-17 11:26:30 Re: SQLSTATE[08006] [7] server closed the connection unexpectedly