I need help connecting my Python application running on a server to a PostgreSQL database hosted on Fly.io. My goal is to automate a process that runs daily, retrieves some data, and inserts it into a specific table in the Fly.io-hosted database. I use python with psycopg.
Postgres cluster NNN-db created
Username: XXX
Password: YYY
Hostname: NNN-db.internal
Flycast: QQQQ
Proxy port: 5432
Postgres port: 5433
Connection string: XXX://XXX:YYY@NNN-db.flycast:5432