For a managed database, can I get a private network segment which can be authorized once for pg_hba, so that each build of our application which makes it to the deployment stage which needs to connect, does not require my manual intervention in a browser?
Subscribe
Share
Submit an 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 to AnswerThese 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.
Hello!
You can certainly use private networking with your managed database. Private networking will be limited between services on the same account in the same data center. The way to properly configure trusted connections, you’ll want to do this through the database’s Settings tab in the Cloud control panel (https://cloud.digitalocean.com/), clicking Edit next to Trusted sources. Here’s more on this process:
https://www.digitalocean.com/docs/databases/postgresql/how-to/secure/
This will still require password authentication during login which
pg_hba.confadjustments would allow you to bypass although our managed databases do not provide file system access to the underlying server so this isn’t possible to accomplish.If you have any issues with setting trusted sources or authenticating, feel free to reach out to our Support team who are always happy to help out!
Swimmingly, Garrett Jansen Developer Support Engineer DigitalOcean