DigitalOcean Managed PostgreSQL Database

DigitalOcean Managed PostgreSQL Database subscription active
You will receive email notifications for new publications on DigitalOcean Managed PostgreSQL Database.
56 Results
  • 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

    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

    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

    How do i migrate from Google Cloud managed pgsql database to a digital ocean managed pgsql server.

    The challenge here is both the source and destination server are both managed servers. So how can i move from Google's managed database to digital oceans managed server. Digital ocean resources (https://www.digitalo...
    1 By kmwendwa DigitalOcean Managed PostgreSQL Database PostgreSQL
  • Question

    How to disable read-only mode when managed database storage is full?

    I have a managed PostgreSQL which went into read-only mode after one of the tables got a little too big and the database storage exceeded its limit. I can't find any way do put it back into write mode so I can free up...
    0 By elab Databases DigitalOcean Managed PostgreSQL Database
  • Question

    Is the connection to hosted postgres TLS 1.2 on public net and TLS 1.3 on private net?

    I have a docker image built with my batch code (running deno and pgc4d) and the DO CA cert for a hosted postgres instance. If I run the docker image (Alpine) locally on my machine (MacOS) using the public connection s...
    0 By BakersDozen DigitalOcean Managed PostgreSQL Database Docker
  • Question

    Ability to set up SSH tunnel to Hosted Database

    Moving from self-hosted postgres to managed postgres, in the past we relied on using an ssh tunnel to connect to the server because we had access to postgres port locked down and we've been using VPN client that has d...
    0 By openside DigitalOcean Managed PostgreSQL Database
  • Question

    Can't make api calls when using asp.net core in docker with nginx and managed postgresql database

    I'm using Ubuntu 18.04 with pre-installed docker solution. My project setup is that I run my Asp.Net Core 3.1 Web Api with EntityFramework Core project in a docker container and I install Nginx on the server directly....
    0 By strofc DigitalOcean Managed PostgreSQL Database API Nginx
  • 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 connect to Postgres managed database accepting TCP/IP connections on port 5432?

    I've have been trying setup a Scalelite load balancer. The load balancer connects to an external Postgres database. I have setup the managed database, made incoming traffic open to all. The server and the managed data...
    1 By elvisron DigitalOcean Managed PostgreSQL Database
  • Question

    Access VPC via Wireguard

    Hi, I have a managed database, and I would like to restrict access to it to VPC only. I have setup a droplet in the same VPC as the managed DB, and configured WireGuard on it. I can succesfully connect to the Wireguar...
    2 By dr42 VPN DigitalOcean Managed PostgreSQL Database
  • Question

    How does my new Postgres DB have maxed out connections immediately after creation?

    Hey so, I'm currently building a site, and it's currently not being shared too widely. Recently, I setup a new DB via postgres managed connections, did a pg_dump, and connected to it. I've done this a couple times so...
    0 By rosspatton PostgreSQL DigitalOcean Managed PostgreSQL Database
  • Question

    How to load data to PostgreSQL managed database via public api in a loop

    I want to load data via public api. Data comes in chunks, so the loop is needed to do the job. The simplest option is writing the script like ``` DO $$ BEGIN FOR counter IN 1..5 LOOP copy weather_json FROM PROG...
    0 By quazerro PostgreSQL DigitalOcean Managed PostgreSQL Database
  • Question

    FATAL: role "doadmin" does not exist when connecting to PostgreSQL Managed DB via Spring Boot JPA

    No matter the user I try, I keep getting this error from Digital Ocean PostgreSQL managed database. It uses the correct URL and everything. So at this point I'm confused why my database would return this to my Spring ...
    0 By neyqdev DigitalOcean Managed PostgreSQL Database PostgreSQL Java
  • Question

    Hot to solve "no pg_hba.conf entry for host "ip", user "db-user", database "db-name", SSL off"

    I have a nodejs app that I'm migrating to digitalocean. I have been getting the same error since Friday. I have tried all solutions I've seen online but none seems to help. e.g adding droplet ip to trusted sources. I...
    0 By busingescott DigitalOcean Managed PostgreSQL Database
  • Question

    How do I increase my managed DB's disk without increasing the other resources?

    I logged into the Digital Ocean console today to find that a notification saying that one of my managed databases is running low on disk space. I tried to go increase the disk size, but the only option I can find that...
    1 By finnn DigitalOcean Managed PostgreSQL Database
  • Question

    Nextcloud cannot connect to Digital Ocean Postgresql

    Hi, I've been trying to migrate a Nextcloud db instance running as a pod in Digital Ocean Kubernetes to Digital Ocean's managed database service unsuccessfully. I've been able to communicate and migrate the data from ...
    0 By clvx DigitalOcean Managed Kubernetes DigitalOcean Managed PostgreSQL Database
  • Question

    What is the recommended way to backup my managed PostgreSQL database?

    I don't see any backup options in the DO admin UI like I do for other droplets. I've tried pg_dumpall but I get this error FATAL: no pg_hba.conf entry for host "<IP>", user "<ADMIN>", database "template1", SSL off Al...
    2 By l0qii DigitalOcean Managed PostgreSQL Database