Question

Access managed Postgresql on App Engine

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.

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

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.

mdausmann • August 24, 2021

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???