A fresh PostgreSQL install on Ubuntu accepts connections from the local system only. The listen_addresses setting defaults to localhost, which allows TCP connections over the loopback interface and nothing else. On a VPS with a public IP address, that is the right state to start from. Opening the database to a remote …