Score:0

Failed to build the PostgreSQL remote connection

es flag

I have tried the method mentioned on the other answers, but only to find they all failed. What I did to the configuration are below.

  1. Modified the "pg_hba.conf" file
# IPv4 local connections:
#host    all             all             127.0.0.1/32            md5
host    all             all             0.0.0.0/0               md5
  1. Modified the "postgresql.conf" file
# - Connection Settings -
listen_addresses = '*'
  1. Restart the server
sudo service postgresql restart

But I still failed to build the remote connection. The port was open by the following command:

xx@xx:~$ netstat -nlt|grep :5432
tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN
tcp6       0      0 :::5432                 :::*                    LISTEN
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.