Administrator can't view tables ("server refused to connect") I'm quite experienced with MSSQL and MySQL/MariaDB, but I'm a newbie re PostgreSQL.
I got everything to work, except for the odd detail that the admin user which I set up during installation can't &quot;view/edit&quot; tables. The error displayed is:

domain.com refused to connect

Here's what works
I installed PostgreSQL 12.3 and pgAdmin4 both on a Ubuntu 20.04 LTS server (Azure VM, CLI only, no GUI). Everything works, I can log in from a browser (domain.com/pgadmin4), and create databases and tables.
This doesn't seem to work
However, when I right-click on a table (View/edit data -&gt; first 100 rows), then I get the error message:

domain.com refused to connect.

Equally strange observation
Also, on another machine, I use Pentaho Data Integration for ETL purposes. From there, I can connect, create tables (via the automatic SQL code it generates), and I can both write and read tables, not a problem at all.
Problem
My only issue is that the admin user in pgAdmin4 cannot read tables (despite the &quot;Administrator&quot; role). I also turned off ufw (the Ubuntu Firewall), and any IP restrictions in the Azure account (which is effectively a second firewall). I also checked the logfile postgresql-12-main.log, but I didn't see any related entries.
I'd really appreciate if someone could give me an idea how to troubleshoot that.
I figured it out, I needed to add two lines in the ssl.conf file:
Header set Access-Control-Allow-Origin &quot;*&quot;
Header set Access-Control-Allow-Methods &quot;GET, POST, PUT, DELETE, OPTIONS&quot;
That solved it (don't forget to restart apache).