Question
Access managed Postgresql on App Engine
- Posted on August 24, 2021
- PostgreSQL
Asked by mdausmann
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.
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!
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.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
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???