cannot remote connect to the postgresql server

Question

I have an Ubuntu guest installed on my mac using virtualbox and vagrant. I installed the postgresql 9.3 on ubuntu.

I try to connect it from the host OS. kept getting operation time out. Is the server running on host "11.11.11.18" and accepting TCP/IP connection on port 5432.

i tried following, still not working.

in vagrant file.

ubuntu.vm.network "private_network", ip: "11.11.11.18"
ubuntu.vm.network "forwarded_port", guest: 3306, host: 3306
ubuntu.vm.network "forwarded_port", guest: 5432, host: 5432

pg_hba.conf

host all all 0.0.0.0/0 md5

postgresql.conf

listen_addresses='*'

what else do i need to check?

If you forward a port - you need to connect to localhost

zerkms
– zerkms

2015-08-06 00:12:36 +00:00
Commented Aug 6, 2015 at 0:12 — zerkms
– zerkms, Commented Aug 6, 2015 at 0:12
@zerkms, thank you. it works now.

qinking126
– qinking126

2015-08-06 00:18:49 +00:00
Commented Aug 6, 2015 at 0:18 — qinking126
– qinking126, Commented Aug 6, 2015 at 0:18

zerkms · Accepted Answer · 2015-08-06 00:19:48Z

1

As soon as you forward ports - you need to connect to localhost instead.

answered Aug 6, 2015 at 0:19

zerkms

256k73 gold badges447 silver badges551 bronze badges

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

Collectives™ on Stack Overflow

cannot remote connect to the postgresql server

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