Question

0

How can I connect to postgres using the IP address of the localhost?

rated 0 times [ 0] [ 0] / answers: 1 / hits: 1617 / 2 Years ago, thu, may 19, 2022, 10:45:07

This is a new installation of Ubuntu 20.04 on OCI. Postgres database has been installed and is running fine. The problem is I am unable to connect to the database using the IP address of the host. Please see the error below.

psql -h 135.145.78.113 -p 5432 -d postgres -U postgres -W

Password:

psql: error: connection to server at "135.145.78.113", port 5432 failed: Connection timed out

        Is the server running on that host and accepting TCP/IP connections?

When localhost is used, it connects as seen below.

psql -h localhost -p 5432 -d postgres -U postgres -W

Password:

psql (13.7 (Ubuntu 13.7-1.pgdg22.04+1))

SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)

Type "help" for help.

Your support is much appreciated.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

wheance

Add To Favorites

Follow

Total Points: 314

Total Questions: 96

Total Answers: 112

Location: Benin

Member since Thu, Aug 12, 2021

3 Years ago

wheance questions

1 Which option ("internet site", "internet with smarthost", "satellite system") should I choose in postfix configuration?

Sat, Dec 25, 21, 22:06, 2 Years ago

1 How can we append asterisk (*) at the end of last line(content) of each and every text file within same directory in Ubuntu 20.10?

Wed, Dec 8, 21, 07:33, 2 Years ago

1 Can I install a multiverse package, then disable non-free sources, and still let it upgrade?

Tue, Oct 5, 21, 01:09, 3 Years ago

1 E: The package android-studio-4.0 needs to be reinstalled, but I can't find an archive for it in Ubuntu 20.04

Wed, Oct 27, 21, 22:34, 3 Years ago

1 How to add sublime text desktop launcher in Ubuntu 20.04.1

Sat, Jun 18, 22, 09:41, 2 Years ago

View All

answered 2 Years ago urvedcaly · Accepted Answer

I'm not sure whether this applies to you as I haven't got consistant info on the IP config, but it might do.

Judging by the picture following, the internal LAN address of your VM would not be the same as the IP you would use to connect remotely. If you are typing your commands on the VM you should use the internal IP address, or continue to use localhost.