Hi! Can someone explain how to enable remote connection (from my local/client machine) to the the Postgres db which I set on the server?

First, I got this couldn’t connect to server connection refused. Then I tried to edit configurations in

pg_hba.conf

by adding this:

host    all             all             89.214.182.137/24        trust

and changing ‘localhost’ in

postgresql.conf

to:

listen_addresses='*'

Still was no result:

sudo iptables -L
Chain INPUT (policy ACCEPT)
target     prot opt source               destination         

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination         

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination