By phosphide
I’ve created pools in my postgresql cluster. In App platform, I need to change the connection settings to point to the pool. The only option is to detach and re-attach and you can’t edit the connection directly (settings -> database -> Database/Pool). There is a drop down showing the pool/non-pool connections, but no save button.
Can this be done without downtime? I can turn on maintenance mode but it’s not ideal.
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!
Accepted Answer
Heya, @phosphide
I believe you can create the pool in your DigitalOcean Managed PostgreSQL cluster if not already done, then manually add the pool connection string as environment variables in the App (instead of using the built-in DB attachment reference). Deploy with the new variables pointing to the pool endpoint. Once confirmed working, you can remove the old attachment.
Hope that this helps!
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.