-
Tech talk
Add authentication to your Next.js application using Next Auth.js, with Postgres as your database.
•
By
Chris Sev
Tech Talks
Next.js
JavaScript
DigitalOcean Managed PostgreSQL Database
-
Tutorial series
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
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
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
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
-
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
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
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
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
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
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
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
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
-
Question
Are the backups made for the managed PostgreSQL stored in the same datacenter as the database itself? If yes, is there a way to have them stored in a different one?
Thanks!
Accepted Answer:
Hello @esd
No, they are not taken at the same location. To ensure data safety we use offsite backups for database cluster(s). Since the service is managed, we handle all backup operations on our end. The backup itsel...
1
•
•
By
esd
DigitalOcean Managed PostgreSQL Database
-
Question
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
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
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
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
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
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
Featured Tech Talk
