-
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
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
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
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 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
As described here - https://www.postgresql.org/docs/current/routine-vacuuming.html#AUTOVACUUM
I didn't see any mention in the DigitalOcean docs, so I assume not, but wanted to make sure - I'm new to pg and not sure wh...
1
•
•
By
bburnskm
PostgreSQL
DigitalOcean Managed PostgreSQL Database
-
Question
Hello,
I have a CI/CD pipeline running in BitBucket. I want to create a Database Cluster on DigitalOcean for my API, so I can migrate to the API to a Kubernetes Cluster. How can I setup my pipeline to be able to deplo...
1
•
•
By
jaaywags
DigitalOcean Managed PostgreSQL Database
Databases
CI/CD
-
Question
I had trouble connecting to digitalocean database in node js and was getting errors such as:
Error: self signed certificate in certificate chain.
or
error: no pg_hba.conf entry for host "x.x.x.x", user "------", d...
2
•
•
By
beuu
Node.js
Databases
DigitalOcean
PostgreSQL
DigitalOcean Managed PostgreSQL Database
-
Question
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...
2
•
•
By
ChellGouda
DigitalOcean Managed PostgreSQL Database
DigitalOcean App Platform
-
Question
Hello, I am noob so forgive me. But I noticed that in my managed postgresql database cluster I am limited to 22 connections. Does that mean only 22 users can use my app at a time!?
Currently a user connects to app -> ...
0
•
•
By
casey7398
DigitalOcean Managed PostgreSQL Database
-
Question
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!
1
•
•
By
casey7398
DigitalOcean App Platform
DigitalOcean Managed PostgreSQL Database
-
Question
Hi,
I have set up a PostgreSQL database cluster with 1 Primary and 1 Standby Node.
How do I test/ensure that replication between the Primary and Standby node, automatic failover and high availability are working?
Any ...
0
•
•
By
trefore
DigitalOcean Managed PostgreSQL Database
High Availability
Needs Product Answer
-
Question
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
Hello,
I am deploying a LAPP (linux, Apache, Postgres & PHP) app on DO and looking for an always available and scalable architecture. Here is my plan
a. set up the webapp in Read only volume
b. set up client files in ...
1
•
•
By
rkrk
LAMP Stack
PostgreSQL
DigitalOcean Managed Kubernetes
DigitalOcean Managed PostgreSQL Database
-
Question
Hi,
I have been trying to connect to my managed database server through node. I am using pg-promise library with the following code which makes use of sslrootcert:
```
"use strict";
const fs = require('fs')
const pgP...
1
•
•
By
Kalimetric
PostgreSQL
DigitalOcean Managed PostgreSQL Database
Node.js
-
Question
Hello Everyone,
I would like to know if the managed PostgreSQL product allows to upload a custom ispell dictionary (https://www.postgresql.org/docs/11/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY), for a ...
0
•
•
By
theelixzammuto
PostgreSQL
DigitalOcean Managed PostgreSQL Database
-
Question
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.
2
•
•
By
kathirva
DigitalOcean Managed PostgreSQL Database
Node.js
Databases