Using postgress app for mac created db.

There are no connection problems from poppy, but when connecting from VM (parallels), an error falls. I opened ports on a Mac and on Windows and still the error does not go away, I don’t know what to do. enter image description here enter image description here

If you run a similar request on a Mac, everything works

    1 answer 1

    Most likely you are allowed to connect only with localhost.

    You need to perform two actions:

    1) Specify the IP-address of the interface through which the virtual machine is connected. You need to do this in the Postgresql server configuration file (postgresql.conf) by adding the line:

    listen_addresses = '<IP шлюза>'

    Or for all interfaces:

     listen_addresses = '*'

    2) Edit the pg_hba.conf file (its location can be found by running the SQL query 'show hba_file;') by adding in it IP addresses with password authorization allowed:

     host all all <IP виртуальной машины> md5

    After these steps, you must restart the server.

    I suppose that in your case it should look like this:

    postgresql.conf

     listen_addresses = 192.168.0.101

    pg_hba.conf

     host all all 192.168.0.0/24 md5
    • one
      And if you need to add an input without ssl hostnossl all all 0.0.0.0/0 md5 - Kirya522