Symptoms

The error may occur during the import into a PostgreSQL database.

Causes and solutions

The postmaster or PostgreSQL's server daemon process is not running or configured incorrectly.

In most cases, you get this error because PostgreSQL is not configured to allow TCP/IP connections, or at least does not allow connections from your specific workstation. If you have verified that postmaster is indeed running on the host you are trying to connect to, here is a list of common causes of this problem:

1. postgresql.conf is not configured to allow TCP/IP connections. You need to view at the listen_address configuration parameter (listen_addresses = '*').
2. postgresql.conf is not configured to allow connections on a non-standard port number. To determine this, view the port configuration option.
3. authentication rules in the PostgreSQL's access configuration file (pg_hba.conf) are not configured so that neither your users nor IP address can connect to this database. Check out the official documentation for more information on how to properly configure pg_hba.conf (host all all 0.0.0.0/0 md5).
4. make sure there are no firewalls like iptables that are preventing your local system from even making a connection to the remote host.

After all changes, restart the server.

If you encounter any difficulties or have additional questions, please contact us at support@ispirer.com.