Problem scenario
You have a Windows desktop computer with HeidiSQL installed on it. You have a Linux server with Postgres installed on it. How do you get your SQL front end (e.g., Hiedi SQL), to work with the Postgres database?
Solution
Part 1 / From the back end:
1. Modify this file /etc/postgresql/9.5/main/postgresql.conf so this stanza is not commented out:
listen_addresses = ‘localhost’
# Make sure in the quotes there is a space and then the external IP address of the Postgres server.
…
Continue reading “How Do You Configure HeidiSQL to Work with Postgres?”