Question

Access managed Postgresql on App Engine

Posted August 24, 2021 99 views
PostgreSQL

I have set up a postgres DB associated with my AppEngine project. It is a ‘Dev Database’.

trying to connect to this DB via the connection parameters in the settings page.

get this error

could not connect to server: Operation timed out
    Is the server running on host "app-17c69336-3fb2-4577-ba9e-01536e399e5d-do-user-429234-0.b.db.ondigitalocean.com" (143.244.178.123) and accepting
    TCP/IP connections on port 25060?

some answers in this community suggest changing firewall settings but this doesn’t appear to be possible through the settings UI.

Some other answers suggest changing trusted sources but my settings UI only suggests 'Add App as a trusted source’

Please advise how I can access this DB via sql either from my local machine or any equivalent sql interface.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

Ok, stoopid me, it’s similar to this issue (https://www.digitalocean.com/community/questions/trusted-sources-not-allowing-connections-from-my-ip) i.e. the ‘Add app as a trusted source’ setting. If this is unchecked, apparently everybody in the universe AND me can now access the database.

How do I add my computers IP to trusted sources???