1

While trying to connect Apache Superset to Google Cloud SQL (PostgreSQL) I get this error:

5432 The port is closed.

I also unsuccessfully tried to connect by SQLAlchemy URI string
postgresql://username:password@host:port/database as well as
PostgreSQL+psycopg2://username:password@host:port/database?sslmode=require;
yielding
Error: Please check your connection details and database settings, and ensure that your database is accepting connections, then try connecting again.

What I used:

  • Superset: 2.1.0 (installed on Google virtual machine)
  • PostgreSQL: 15.2 (Google Cloud SQL)

Can somebody help to understand and solve?

greybeard
  • 2,249
  • 8
  • 30
  • 66
Vadym Urupa
  • 31
  • 5

1 Answers1

2

Private IP has to be created in cloud SQL to connect to Superset. Link to the docs

Sebastian Liebscher
  • 174
  • 10
Vadym Urupa
  • 31
  • 5
  • While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - [From Review](/review/low-quality-posts/34934862) – Arkellys Sep 02 '23 at 18:05