DigitalOcean Managed PostgreSQL Database

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

    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...
    1 By l0qii DigitalOcean Managed PostgreSQL Database
  • Question

    Is it possible to do Load Balancing on Managed DB?

    Hi, I have this project that has a great hit on read queries so I was wondering if I can use Managed DB to have a main node and many R/O nodes, but the question is how to do the load balancing in this case? How to do...
    2 By esteban DigitalOcean Managed PostgreSQL Database
  • 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...
    0 By gauravmjoshi DigitalOcean Managed PostgreSQL Database
  • Question

    Better Option for Angular / Node JS / PostgreSQL

    I created 2 option for hosting angular/nodejs/postgresql application. The app is a simple POS system that will probably be used by 2-3 persons. Here is the of the options I made. Check page 2 for the prod environment...
    0 By lueenavarro DigitalOcean Managed Kubernetes DigitalOcean Managed PostgreSQL Database DigitalOcean Volumes
  • Question

    Is it possible to download the managed database's `ca-certificate.crt` using the DO API, or similar?

    I would like to fully automate the generation and configuration of database client credentials. Are custom certs a consideration for future versions of the managed database service?
    1 By beauzo DigitalOcean Managed PostgreSQL Database
  • Question

    Declare cursors

    I'm trying to declare CURSOR on table with ~9M records DECLARE "name" NO SCROLL CURSOR WITH HOLD FOR SELECT .... and it fails with error: <^>terminating connection due to administrator command.<^> No logs, nothing. ...
    0 By periparts DigitalOcean Managed PostgreSQL Database
  • Question

    Need clarification on connection pool sizing with read-only nodes

    I have a postgres database with one read-only node. In the control panel, I see that my database has a total of 97 available backend server connections. Does that mean that there are 97 server connections over all ...
    1 By johnnymags DigitalOcean Managed PostgreSQL Database
  • Question

    Unhandled Error that occurs only sometimes

    Sometimes when I make an API request, my API returns the error: Unhandled error in GET /api/endpoint 500 Error: getaddrinfo ENOTFOUND db-postgresql-nyc3-32178-do-user-7115232-0.db.ondigitalocean.com db-postgresql-nyc3...
    0 By vikramkh DigitalOcean Managed PostgreSQL Database
  • Question

    Setting up user with pg_monitor role

    In order to do datadog monitoring I need an user with the role pg_monitor, however I cannot grant this role since I need the admin option, which can only be given when initially granting the role to an user (which you...
    0 By hest PostgreSQL DigitalOcean Managed PostgreSQL Database
  • Question

    Is it possible to use a VPN IPSEC Site-to-Site connection to a Digital Ocean's PostgreSQL

    I need to configure a VPN IPSEC Site-to-Site connection to a Digital Ocean's PostgreSQL and dont know if its possible or how to do it.
    0 By ruicastelhano DigitalOcean Managed PostgreSQL Database
  • Question

    Suggestions: alert policies within managed databases that match the metrics offered

    I'm using a PostgreSQL managed database. (I assume this is applicable to all of the managed databases, MySQL and Redis, too.) The Manage alert policies option on the Insights tab allows to create/edit alerts... but th...
    1 By BrianIbbotson DigitalOcean Managed PostgreSQL Database
  • Question

    How do i connect postgresql db from visual studio 2019 ?

    hi everyone , here's what i've been trying : step#1 : sign in to DO , in the Database CLuster, select Connection Details . step#2 : in Visual Studio 19 , Tools > Connect to Database > Change Data source to PostgresSQL...
    1 By menarsikya PostgreSQL DigitalOcean Managed PostgreSQL Database
  • Question

    Local hot standby slave that can connect to a remote master (managed database)?

    I would like to know if it is posible to configure a local hot standby slave that can connect to a remote master (managed database), since we can't configure the config of a managed database, is there an alternative w...
    1 By rooseveltpv DigitalOcean Managed PostgreSQL Database
  • Question

    How can I reset the postgres "Query statistics" section?

    The "Query statistics" section is great for finding slow queries so they can be speed up. However, once the query is improved I would like a way to reset these statistics so the old, slow queries are gone. Is there a ...
    0 By nathanielobrown DigitalOcean Managed PostgreSQL Database
  • Question

    How can I add the CA certificate of my postgres cluster to a docker container?

    The docker image is dotnet core and the posgrsql cluster is managed by digital ocean, I already got the connection from my local machine (windows) but I don't know how to do it from the container (linux)
    1 By hyperh4wk Docker PostgreSQL DigitalOcean Managed PostgreSQL Database
  • Question

    How to connect to remote database on digital Ocean with pycharm ?

    I am using Pycharm and I would like to connect to remote database to edit it. However I have this following error : [08P01] ERROR: no such database: [08P01] ERROR: no such database: ` I insert those features in the co...
    1 By devjo DigitalOcean Managed PostgreSQL Database