Question
How do I connect to a postgres connection pool with managed databases?
- Posted on April 23, 2020
- DatabasesPostgreSQL
Asked by Garrett Bland
We have decided to use Postgres and digital oceans managed databases for our next project. This database will handle about 10 million page visits a month, with certain points having spikes in traffic. We created a database, and were able to connect to it just fine.
We created a new connection pool, and the connection details are different than our other database. It has a different port and a different database listed. When we try to connect with the connection pool details, we get the error database "test-pool" does not exist
We are also using sequelize 5.xx and node js. Haven’t had any issues up until trying to utilize connection pooling. Any ideas or suggestions?
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.
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 SMBs
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.
To answer my own question, use the pool name to connect instead of the db name.
I hope this helps people who might have the same question out.