DigitalOcean Managed PostgreSQL Database

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

    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

    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

    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 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

    no pg_hba.conf entry for host \"IP-ADDRESS", user \"username\", database \"database\", SSL off

    I am trying to access my managed postgreSQL database from my node.js app which is hosted in Google Cloud. I am getting the above error. I am using pg-promise in my node.js app. How to go about it? Please advise.
    1 By kathirva DigitalOcean Managed PostgreSQL Database Node.js Databases
  • Question

    Managed PostgreSQL & RabbitMQ Plugin

    Hey there, I am currently using PostgreSQL (Managed) from DO. Does anybody know, if it's possible to install 3rd party plugins, like for example "pg_amqp"? https://pgxn.org/dist/pg_amqp/ Thanks in advance, Oliver
    0 By odorakel PostgreSQL DigitalOcean Managed PostgreSQL Database
  • Question

    Connecting to Managed Postgres Database / what should I do with .crt file?

    I'm in the process of switching over to a managed Postgres database. I'm using the node-postgres library and I was able to connect to the managed db from my node app using this code: const pool = new Pool({ ssl: { ...
    0 By mokey DigitalOcean Managed PostgreSQL Database Node.js
  • Question

    What's the best way to run pg_cron on a database other than defaultdb?

    Since pgcron is now supported in PostgreSQL 12 managed db, what would be the best way to use it if we have a database that is not defaultdb? Currently you can only install the pgcron extension into defaultdb. Since pg...
    1 By captaincurlyfry DigitalOcean Managed PostgreSQL Database PostgreSQL
  • 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

    Cannot remote connect to postgresql

    I'm having problems to remote connect to PostgreSQL. I'm getting this error (https://www.digitalocean.com/docs/databases/postgresql/resources/troubleshoot-connections/#connection-refused-hostname) I'm using right port...
    1 By PalumboWeb PostgreSQL Databases 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...
    2 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...
    1 By elab Databases DigitalOcean Managed PostgreSQL Database
  • 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

    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

    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

    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

    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