Thread: could not connect via psql to 9.4 version

could not connect via psql to 9.4 version

From

Murali Paramu

Date:

13 February 2020, 19:22:52

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 5432
psql: 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"?

~~~~~~~~~~~~~
സ്നേഹാദരങ്ങളോടെ
ഐ.പി.മുരളി
thanks & regards,
i.p.murali

Re: could not connect via psql to 9.4 version

From

Rahul Saha

Date:

13 February 2020, 19:31:28

Hi Murali,

Is the 9,4 instance up and running? Check ps -ef|grep -i postgres | grep 5432

Check few other settings if not connecting locally like

#listen_addresses = 'localhost'(making to *) or pg_hba.conf settings.

On Thu, Feb 13, 2020 at 9:53 PM 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 5432
psql: 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"?

--
~~~~~~~~~~~~~
സ്നേഹാദരങ്ങളോടെ
ഐ.പി.മുരളി
thanks & regards,
i.p.murali

Thanks & Regards

Rahul Saha

+91 8806351116

Re: could not connect via psql to 9.4 version

From

"David G. Johnston"

Date:

13 February 2020, 19:43:47

On Thu, Feb 13, 2020 at 9: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 5432
psql: 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"?

So what is the configuration in pgAdmin for its connection to the 9.4 server? You need to make your psql invocation match.

David J.

Re: could not connect via psql to 9.4 version

From

Jeff Janes

Date:

13 February 2020, 20:10:47

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 5432
psql: 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

Re: could not connect via psql to 9.4 version

From

zurich@nym.hush.com

Date:

13 February 2020, 20:24:10

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

Re: could not connect via psql to 9.4 version

From

abbas alizadeh

Date:

14 February 2020, 14:22:17

Hi.

You should use the right psql for version 9.4.

In linux run “which psql” to see which version is used to connect

Sent from my iPhone

On Feb 14, 2020, at 01:11, 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 5432
psql: 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

Re: could not connect via psql to 9.4 version

From

Murali Paramu

Date:

15 February 2020, 17:45:26

Thank you all guys for the help...

when i use right psql it connected.

/opt/PostgreSQL/9.4/bin$ /opt/PostgreSQL/9.4/bin/psql -U postgres

On Fri, Feb 14, 2020 at 3:22 PM abbas alizadeh <ramkly@yahoo.com> wrote:

Hi.
You should use the right psql for version 9.4.
In linux run “which psql” to see which version is used to connect

Sent from my iPhone

On Feb 14, 2020, at 01:11, 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 5432
psql: 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

~~~~~~~~~~~~~
സ്നേഹാദരങ്ങളോടെ
ഐ.പി.മുരളി
thanks & regards,
i.p.murali