CODEWITHSUNDEEP
postgresqloraclelinux
fuchcar
fuchcar

Reputation: 15

Connect to a remote postgresql database from oracle linux 8

I'm running an Oracle Linux 8 instance which I connect to via ssh public key authentication. There I've installed PostgreSQL but I can't seem to access it locally (from DBeaver for example).

I've made these following changes:

set listen_addreses to '*' at the postgresql.conf

added "host all postgres 0.0.0.0/0 md5" at the end of pg_hba.conf

I added postgresql to the firewall by running

sudo firewall-cmd --add-service=postgresql --permanent

sudo firewall-cmd --reload

I even tried disabling the firewall with

sudo systemctl stop firewalld

sudo systemctl disable firewalld

without any success.

And of course I restarted postgresql after the changes with

sudo systemctl restart postgresql.service

However nothing was successful. I've had success by making these changes on other servers previously, but not this time.

And yes postgresql is definitely running

Any help would be appreciated. Thank you.

EDIT: Error message:

OperationalError: connection to server at "<ip address>", port 5432 failed: Connection timed out (0x0000274C/10060)
    Is the server running on that host and accepting TCP/IP connections?

Connection details:

Upvotes: 0

Views: 452

Answers (0)

Related Questions