DigitalOcean Managed PostgreSQL Database

DigitalOcean Managed PostgreSQL Database subscription active
You will receive email notifications for new publications on DigitalOcean Managed PostgreSQL Database.
134 Results
  • Tutorial series

    How To Manage Infrastructure with Terraform

    Terraform is a popular open source Infrastructure as Code (IAC) tool that automates provisioning of your infrastructure in the cloud and manages the full lifecycle of all deployed resources, which are defined in sourc...
    By Savic, Mitchell Anicas and Brian Hogan Terraform Cloud Computing Configuration Management System Tools API Nginx Load Balancing DigitalOcean Managed Load Balancers DNS Apache Python DigitalOcean Infrastructure DigitalOcean Spaces Ansible DigitalOcean Managed PostgreSQL Database
  • Tech talk

    Next.js Authentication

    Learn how to authenticate your Next.js apps using NextAuth.js, an open source authentication tool that's flexible, easy to use, and secure, while using Postgres as your database.
    By Chris Sev Tech Talks Next.js JavaScript DigitalOcean Managed PostgreSQL Database
  • Tech talk

    Using Prisma With PostgreSQL (Let's Build a Node API!)

    Use Prisma to make app building easy by connecting to PostgreSQL on DigitalOcean.
    By Chris Sev PostgreSQL DigitalOcean Managed PostgreSQL Database Tech Talks
  • Tech talk

    What's New In DigitalOcean Managed Databases

    Migrate your data quickly, get more powerful instances, and see how leveraging DigitalOcean Managed Databases allows you to focus on what's important — building your product.
    By Mark Huber Tech Talks Databases DigitalOcean Managed MySQL Database DigitalOcean Managed PostgreSQL Database DigitalOcean Managed Redis
  • Tutorial

    How To Deploy Your Own Web Analytics Software with Umami on DigitalOcean's App Platform

    Umami is an open-source web analytics software. This tutorial covers cloning the Umami repository, creating PostgreSQL tables, setting up connection pools, and deploying Umami to the App Platform.
    By OkezieUC Databases PostgreSQL DigitalOcean Managed PostgreSQL Database DigitalOcean App Platform
  • How To Use Terraform With Your Team

    In this tutorial, you'll create an organization in Terraform Cloud to which you'll connect your project. You'll then use your orgnanization to set up workspaces and resources. You will store your state in the managed ...
    By Savic Terraform Cloud Computing DigitalOcean Managed PostgreSQL Database
  • Question

    Not able to Install "plperlu" as Extension for Postgres managed database

    Hi, When I am trying to create the Postgres extension "plperlu", I am getting the below error. defaultdb=> CREATE EXTENSION plperlu; ERROR: permission denied to create extension "plperlu" HINT: Must be superuser to...
    Accepted Answer: Hi there, Unfortunately, DigitalOcean does not support the "plperlu" Postgres extension as it's an untrusted language that would allow the full ability to access anything the Postgres process can. This extension will ...
    1 By Rajkishore DigitalOcean Managed PostgreSQL Database PostgreSQL
  • 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...
    Accepted Answer: Hi all, This has been implemented and can be achieved by following the steps here: https://docs.digitalocean.com/products/app-platform/how-to/manage-databases/ Hope that this helps! Regards, Bobby
    19 By ChellGouda DigitalOcean Managed PostgreSQL Database DigitalOcean App Platform
  • Question

    Import CSV stored in Spaces into Managed Postgres

    Does Digital Ocean have any tools or services to facilitate the importing of a csv file stored in a DO Space into a DO Managed PostgreSQL database? Ideally we'd like to build a process so that we can upload a csv fil...
    Accepted Answer: Hi there, I believe that there is no such tool out of the box. However what I would suggest is putting together a small script that would fetch the file from the Spaces, parse it and import it to your database. You co...
    1 By BigLightSeaGreenWalrus DigitalOcean Spaces DigitalOcean Managed PostgreSQL Database
  • Question

    setup multiple databases on one postgres server with different users for each

    Hi I am using the digital ocean managed database, but I wanna be able to host more then one database, for more then one application at once, for security I want to restrict each database to a specific user and then ad...
    Accepted Answer: Hi there, Yes, this is doable. You can do this by modifying the user privileges. You can follow the steps on how to do that here: https://docs.digitalocean.com/products/databases/postgresql/how-to/modify-user-privileg...
    1 By aluf DigitalOcean Managed PostgreSQL Database PostgreSQL Databases
  • Question

    How to backup a managed postgres database with 10000+ tables

    Hi, We have a managed postgres database with digital ocean with a large number of tables. Running a normal pg_dump will crash as it needs a lock per table and is exceeding whatever the managed clusters configured post...
    Accepted Answer: Hi @nigelgott, You can open a support ticket with us to increase 'maxlocksper_transaction', we will be able to help you with this. Regards, Rajkishore
    1 By nigelgott DigitalOcean Managed PostgreSQL Database
  • Question

    How to connect Postgres managed database as a datasource in Google Data Studio

    Hello, I want to connect Postgres managed database to google data studio but I get an error while trying to establish a connection. any guidance will be helpful.
    Accepted Answer: Hi Please follow the below steps to connect Postgres Managed database as the data source for google data studio 1) Downloaded the CA certificate for your DigitalOcean instance from the console ( this will be a Server ...
    1 By Rajkishore DigitalOcean Managed PostgreSQL Database PostgreSQL
  • Question

    Django admin panel css not working as expected

    I am trying to deploy django project in digital ocean ,my site's css is working perfectly but my admin panel css is not working good, the dashboard of the datbase window overrides my entry page always before few days...
    Accepted Answer: if you are github to get to your on production server please delete your delete your static root directory on production and generate that by the following command "python manage.py collectstatic" i my case STATIC_UR...
    1 By apothecaryre DigitalOcean DigitalOcean Managed PostgreSQL Database Django Python Initial Server Setup
  • 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!
    Accepted Answer: Hi all, This has been implemented and can be achieved by following the steps here: https://docs.digitalocean.com/products/app-platform/how-to/manage-databases/ Hope that this helps! Regards, Bobby
    6 By casey7398 DigitalOcean App Platform DigitalOcean Managed PostgreSQL Database
  • Question

    How to check metrics like CPU, Disk, RAM utilization in Managed database cluster.

    I want to know how to check disk, cpu and RAM usage of the managed MySQL and Postgresql database cluster?
    Accepted Answer: Hi, To view performance metrics, click the name of the database to go to its Overview page, then click the Insights tab. The Select object drop-down menu lists the cluster itself and all the databases in the cluster....
    1 By priyankamalik DigitalOcean Managed MySQL Database DigitalOcean Managed PostgreSQL Database MySQL PostgreSQL
  • Question

    Why Managed Database can't have App Platform as Trusted Source ?

    Hello, I'm looking to restrict the access of my Managed Database to only App Platform but it appears that we can't actually, or I am missing something ? This is a very high security issue ! Thanks,
    Accepted Answer: Hi all, This has been implemented and can be achieved by following the steps here: https://docs.digitalocean.com/products/app-platform/how-to/manage-databases/ Hope that this helps! Regards, Bobby
    4 By scorsi DigitalOcean App Platform 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/).
    2 By niklasCrab DigitalOcean App Platform DigitalOcean Managed PostgreSQL Database
  • Question

    How to secure database connection to App Platform?

    As I understand, the databases in cluster are accessible over the network from anywhere. What's the recommended way for securing an Database connection with App Platform application? How to set it up so that nobody el...
    Accepted Answer: Hello all, We now have this feature of Trusted sources on App Platform. Refer to below link for more insights: https://docs.digitalocean.com/products/app-platform/how-to/manage-databases/ https://docs.digitalocean.com...
    2 By MihkelL DigitalOcean App Platform DigitalOcean Managed PostgreSQL Database
  • 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

    Database cluster constant connection

    Hey, I created a PostgreSQL database cluster. Since then, even with trusted sources set to any IP. I have a constant "1 connection". I don't know if this connection comes from Digital Ocean or a pending connection tha...
    Accepted Answer: Hi there, The connection you're seeing to the database might be the agent connection for system metrics. The max backend Connections are defined according to the cluster size and system or agent connections do not cou...
    1 By Kiyozz Databases DigitalOcean Managed PostgreSQL Database