pgmon connect 111: Connection refused about pgmoon HOT 5 CLOSED

You should have a look in your pg_hba.conf file. psql is not connecting over a local IPv4 connection but over a Unix socket; hence, although you used the same user, you might get a different result.

from pgmoon.

pg_hba.conf

 host    all             mqtt             192.168.25.10/32       trust                                                                                                                                      
 host    all             mqtt             192.168.8.31/32        trust     

I'm test psql connect on other host , different with postgresql server . postgresql server run on the 192.168.25.100, psql client run on the 192.168.25.10. lua script also run on the 192.168.25.10.

from pgmoon.

There's something else going on here. psql when passed a host parameter (-h 192.168.25.100) does use an IPv4 TCP/IP connection, not a local Unix socket. (Note: psql couldn't use a local Unix socket to connect to a remote host.)

@yjdwbj, I'm just grabbing at straws, but try specifying a port number as a number, not a string.

  port = 5433

instead of

  port = "5433"

from pgmoon.

Yeah my bad, I totally overlooked the issue here; just so used to seeing the same issue over and over again 😅

from pgmoon.

Coming back to this now that the holidays are over. Did you solve your problem?

If not, how did you install pgmoon? I'm wondering if this error is coming from missing dependencies like luasocket if you're running from the console. If you're in OpenResty, the socket connection should be coming from nginx.

from pgmoon.