Remote connection to postgres running on Ubuntu

Question

I'm struggling to enable remote connection on Postgres running on Ubuntu. I've done the following steps:

Opened up the firewall; running sudo netstat -ntlp | grep LISTEN gives me:

tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      2947/postgres

Added in listen_addresses to postgresql.conf:

listen_addresses='*'            # what IP address(es) to listen on;
                                # comma-separated list of addresses;
                                # defaults to 'localhost'; use '*' for all

Added in the connection table in pg_hba.conf as follows:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer

I can connect locally but I cannot connect remotely; not even connecting via telnet works. It just says connection refused. Has anyone got an idea as to the cause of the problem?

Thanks.

Cheers,
Neil

How exactly are you trying to connect?

Laurenz Albe
– Laurenz Albe

2016-11-11 13:02:36 +00:00
Commented Nov 11, 2016 at 13:02 — Laurenz Albe
– Laurenz Albe, Commented Nov 11, 2016 at 13:02

Tometzky · Accepted Answer · 2016-11-11 16:12:25Z

0

Restart postgres

Check if it's listening on all interfaces

# netstat -lnp --tcp | grep postgres
tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN      6096/postgres

Add host line to pg_hba.conf:

host    all             all             0.0.0.0/0               md5

Add a password for your user

$ sudo -u postgres psql
postgres=# \password username

answered Nov 11, 2016 at 16:12

Tometzky

24.2k5 gold badges64 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Remote connection to postgres running on Ubuntu

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related