MIME-Version: 1.0
Date: Thu, 13 Feb 2020 17:24:10 +0000
To: "Murali Paramu" <ipmurali@gmail.com>
Cc: "pgsql-admin" <pgsql-admin@postgresql.org>
Subject: Re: could not connect via psql to 9.4 version
From: zurich@nym.hush.com
In-Reply-To: 
 <CAMkU=1wwn0bLcXVhWcaPLr8=ZecQwY1yK8i0h419r7vn7b_+YQ@mail.gmail.com>
References: 
 <CAC9RKdOmWV7ePWDpUJZSmNor8jePoCtKc+uYrp=ccUYrrEwuBQ@mail.gmail.com>
 <CAMkU=1wwn0bLcXVhWcaPLr8=ZecQwY1yK8i0h419r7vn7b_+YQ@mail.gmail.com> 
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="UTF-8"
Message-Id: <20200213172411.0BB2F20118@smtp.hushmail.com>
Precedence: bulk

Have you checked the local settings in the pg_hba.conf as this will affect permitted access. 

You can compare what is set differently between the different versions of postgreSQL. 

Cheers

Peter

On 2/13/2020 at 5:11 PM, "Jeff Janes" <jeff.janes@gmail.com> wrote:
>
>On Thu, Feb 13, 2020 at 11:23 AM Murali Paramu 
><ipmurali@gmail.com> wrote:
>
>> Hello Team,
>> I have two versions of PostgreSQL 9.4 and 12.1
>> both servers can be connected through pgAdmin.
>> But through psql I can connect only to 12.1
>>
>> when i connect to 9.4 got below error:
>>
>>
>>
>>
>> *$ psql -U postgres -p 5432psql: error: could not connect to 
>server: could
>> not connect to server: No such file or directory Is the server 
>running
>> locally and accepting connections on Unix domain socket
>> "/var/run/postgresql/.s.PGSQL.5432"?*
>>
>>
>Perhaps 9.4 is configured to put its socket file in /tmp instead of
>/var/run/postgresql/.  You can try -h /tmp, or you can just always 
>use -h
>127.0.0.1, then you don't need to worry where the socket file is.
>
>Cheers,
>
>Jeff