I have a VM with IP address 192.168.0.192 running postgreSQL.
If I specify
listen_addresses = '*'
then I can connect from another VM at 192.168.0.191 and from localhost.
But I can't seem to use a list to tell postgreSQL to use those two addresses. If I change listen_addresses to a list:
listen_addresses = '192.168.0.191, localhost'
then I can no longer connect from 192.168.0.191.
I notice that almost all examples on stackexchange set listen_addresses to '*'. Is this because the list form does not work?