From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Joseph Brenner <doomvox(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Select works only when connected from login postgres |
Date: | 2016-12-04 15:06:47 |
Message-ID: | 36365c87-eb73-20bc-214a-0225587b73c4@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On 12/03/2016 09:38 PM, Joseph Brenner wrote:
>> So is the 9.4 instance the production/live database?
>
> Essentially, but it's not heavily used: this is me messing around on a dev box.
>
>> So what happens when you specify the port in your psql connection, eg:
>> /usr/local/pgsql/bin/psql --dbname=doom --username=doom -p 5432
>> /usr/local/pgsql/bin/psql --dbname=doom --username=doom -p 5433
>> /usr/local/pgsql/bin/psql --dbname=doom --username=doom -p 5434
>
> With /usr/local/pgsql/bin/psql, only "-p 5433" connects, the
> other two complain like so:
>
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5434"?
>
Alright how about?:
/usr/bin/psql --dbname=doom --username=doom -p 5434
My suspicion is that when you did the source build you got some cross
contamination of libraries.
If it where me I would get rid of the instance that you built from
source, assuming that there is nothing important on it.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2016-12-04 15:41:10 | Postgres and LibreOffice's 'Base' |
Previous Message | imagenesis@gmail.com | 2016-12-04 12:28:24 | count(*) in binary mode returns 0 |
From | Date | Subject | |
---|---|---|---|
Next Message | Fabien COELHO | 2016-12-04 16:35:55 | Re: PSQL commands: \quit_if, \quit_unless |
Previous Message | Michael Paquier | 2016-12-04 14:20:05 | Re: [PATCH] Reload SSL certificates on SIGHUP |