DigitalOcean Managed PostgreSQL Database

DigitalOcean Managed PostgreSQL Database subscription active
You will receive email notifications for new publications on DigitalOcean Managed PostgreSQL Database.
89 Results
  • Question

    How can I put my app (App Platform) in my VPC?

    As of right now, I could not find a way to put my App Platform's App in a VPC so that I can restrict access using Trusted Sources on my database. I can't add any app related information in my Trusted Sources of my dat...
    Accepted Answer: VPC functionality or the ability to list a database in trusted sources is on our roadmap, but not currently available. In the mean time we recommend using TLS to secure your connection and using strong passwords. Wa...
    1 By GiantGreenBlueStarfish DigitalOcean App Platform DigitalOcean VPC DigitalOcean Managed PostgreSQL Database
  • Question

    When will Apps be able to use Postgres with firewall?

    We are about to put up a production environment using Apps and a Hosted Postgres database, but the fact that you cant lock the postgres down by IP is holding us off. Having a production database exposed to the interne...
    Accepted Answer: 👋 This is a priority on our roadmap. We encourage you to follow our online Release Notes documentation (https://www.digitalocean.com/docs/release-notes/app-platform/).
    1 By niklasCrab DigitalOcean App Platform DigitalOcean Managed PostgreSQL Database
  • Question

    Can a DB standby node have a different version than the primary?

    We have a our database managed by DigitalOcean and a few days ago whilst our DB was overloaded we got a peculiar error in our Rails project which after looking into it quite a bit the only thing that I believe could h...
    Accepted Answer: Hey there, No, it's not possible and Standby nodes are exact copies of the primary node (including DB version) that automatically take over if the primary node fails. You might have to look into it further to find the...
    1 By keeyan DigitalOcean Managed PostgreSQL Database Needs Product Answer
  • Question

    How to manage user privileges in PostgreSQL cluster with multiple databases/users?

    I want to use a single Managed PostgreSQL cluster from DO to host multiple applications (since they're all small, there's no need to have a unique cluster per app). From what I've gathered, permissions and user privil...
    Accepted Answer: Hey @slig - This syntax should work perfectly! Cheers!
    1 By slig DigitalOcean Managed PostgreSQL Database PostgreSQL
  • Question

    How can I create good diagrams for my infrastructure architecture based on DigitalOcean products?

    I build interesting applications using best practices in infra architecture and would love to be able to write/blog about them. However, I lack the tools to be able to create good architecture diagrams for all the di...
    Accepted Answer: A great resource for creating architecture diagrams for infrastructure configurations based on DigitalOcean can be found here: https://do.co/diagram-kit
    1 By rsharma DigitalOcean Managed Kubernetes DigitalOcean Managed Load Balancers DigitalOcean Managed PostgreSQL Database DigitalOcean Managed MySQL Database DigitalOcean Spaces DigitalOcean Volumes
  • Question

    Where can I find Client Certificate so as to be able to connect to Managed Postgre Instance using Pgadmin

    Hi, I am completely new to cloud server and to PostgreSQL. I would like to setup a SSL Connection with PostgreSQL managed database on Digital Ocean. I downloaded the CA certificate. However, when I try to use the CA c...
    Accepted Answer: Hi there @gauravmjoshi, I've just tested this, what you need is the following, under the SSL section specify: Set the SSL mode to Required You need to download your CA certificate and add it under the Root Certificate...
    1 By gauravmjoshi DigitalOcean Managed PostgreSQL Database
  • Question

    Ho to create database cluster with trusted sources with CLI or terraform ?

    I can not figure out how to create a managed database and set trusted sources with CLI (docli) or better Terraform. From the documentation: Endpoint: "https://api.digitalocean.com/v2/databases" Body: { "name": "bac...
    Accepted Answer: Hello, This was very recently implemented to the DigitalOcean API, now the API supports managing a database cluster’s firewall rules (or “trusted sources” as they are called in the control panel). You can use this en...
    1 By marekgmyrek DigitalOcean API and CLI (doctl) DigitalOcean Managed PostgreSQL Database
  • Question

    Disk space used

    Where to see how much disk space is currenly used by a particular managed database? Can't find this information in the admin panel: only the space limits.
    Accepted Answer: Hello, To check that you could do the following: Go to your control panel at https://cloud.digitalocean.com/ Then go to your managed database instance Click on 'Insights' then from the dropdown choose the name of you...
    1 By scabbiaza DigitalOcean Managed PostgreSQL Database
  • Question

    How many databases can I create for $ 15?

    I want to buy postgre database hosting for 15 USD. I want to know this price(15 USD) only one postgre database price or can I create more than one database? (If so please tell me limits databases) thanks.
    Accepted Answer: Hello, There are no limits to the databases that you can create on your Managed database cluster. It would be the size of your databases that would matter. For example, with the 15$/mo Managed PostgreSQL Database Clus...
    1 By telmandel DigitalOcean Managed PostgreSQL Database
  • Question

    How much database space remains available?

    I have a Postgres server on the DBaaS service. I can see how much space an individual database is using with via the database statistics page in pgAdmin4. But how can I check the amount of space that is still availa...
    Accepted Answer: Hello, @lwyatt This should be visible in the Digital Ocean control panel in the Cluster metrics. To view performance metrics, click the name of the database to go to its Overview page, then click the Insights tab. Yo...
    1 By lwyatt DigitalOcean Managed PostgreSQL Database
  • Question

    Postgres query stop after 10 minutes

    I have Managed Postgres instance, and a query that stops after 10 minutes. The query is REFRESH MATERIALIZED VIEW xyz. I kind looks like there is a limit for a query to run for 10 minutes. Can anyone tell what parti...
    0 By efficientcapital DigitalOcean Managed PostgreSQL Database
  • Question

    PostgreSQL: could not translate host name: <address> to address: Temporary failure in name resolution

    I am trying to migrate postgre db from DO VM into DO's PostgreSQL managed database. I used pg_dump for specific database, and use pg_restore to load the data. All went well, except until I turn off the old VM, queryi...
    1 By napjon DigitalOcean Managed PostgreSQL Database
  • Question

    How to Link Dokku App to Managed Database

    I have a small problem here. I have an app setup on Dokku vps, works well with the Dokku Postgress plugin. But I want to switch things up and use the digitalOcean managed Database(Postgress) Since changing the databa...
    0 By mo6ibe PostgreSQL Dokku Docker DigitalOcean Managed PostgreSQL Database
  • Question

    How to add my DigitalOcean App as a trusted resource for my Managed Database

    I have signed up for the Managed Database for Postgreql. Now I have also signed up for a DigitalOcean App and selected the Managed Database as the database. There was a message telling me that I have restricted acces...
    9 By ChellGouda DigitalOcean Managed PostgreSQL Database DigitalOcean App Platform
  • Question

    How to downscale a Managed Database

    I have a managed Postgres Database that I temporarily scaled up to the $60/month version, to account for an expected spike. Since the spike is over, I'd like to go back down to the $30/month node plan. However, these...
    1 By winsmith DigitalOcean Managed PostgreSQL Database Needs Product Answer
  • Question

    How is a managed databased accessed by a Kubernetes cluster?

    How is a managed databased accessed by a Kubernetes cluster?
    1 By robDolphin DigitalOcean Managed Kubernetes DigitalOcean Managed PostgreSQL Database
  • Question

    How to encrypt data at rest for PostgreSQL database?

    As I read this article https://www.digitalocean.com/blog/announcing-managed-databases-for-postgresql/ I understood that all data at rest and in transit is encrypted. Could somebody provide me with more information abo...
    0 By viktorhrtanek DigitalOcean Managed PostgreSQL Database
  • Question

    App Platform Bug - Cant set as a trusted source for Database Cluster

    There is a bug in the new App Platform. If you use DigitalOcean Database Cluster, you cannot select an App Platform app as a trusted source. Pretty glaring oversite!
    2 By casey7398 DigitalOcean App Platform DigitalOcean Managed PostgreSQL Database
  • Question

    How to connect to PostgreSQL cluster on DigitalOcean from CircleCI or Github Actions?

    I have a Kubernetes cluster setup on DigitalOcean and a separate database Postgres instance there. In database cluster settings there is a list of limited IP addresses that have an access to that database cluster (loo...
    0 By vashchukmaksim Kubernetes DigitalOcean Managed PostgreSQL Database PostgreSQL Deployment
  • Question

    Managed Postgres is missing libprotobuf-c (support for vector tiles)

    Hello, I'm really excited about the managed postgres offering, especially with PostGIS enabled by default. Unfortunately, it was not compiled with support for protocol buffers (protobuf). I found out during runtime w...
    0 By gijsnijholt PostgreSQL DigitalOcean Managed PostgreSQL Database Needs Product Answer