-
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
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
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
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...
1
•
•
By
kmwendwa
DigitalOcean Managed PostgreSQL Database
PostgreSQL
-
Question
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...
0
•
•
By
elab
Databases
DigitalOcean Managed PostgreSQL Database
-
Question
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
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
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
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
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
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
-
Question
Hey so,
I'm currently building a site, and it's currently not being shared too widely.
Recently, I setup a new DB via postgres managed connections, did a pg_dump, and connected to it. I've done this a couple times so...
0
•
•
By
rosspatton
PostgreSQL
DigitalOcean Managed PostgreSQL Database
-
Question
I want to load data via public api. Data comes in chunks, so the loop is needed to do the job. The simplest option is writing the script like
```
DO $$
BEGIN
FOR counter IN 1..5 LOOP
copy weather_json FROM PROG...
0
•
•
By
quazerro
PostgreSQL
DigitalOcean Managed PostgreSQL Database
-
Question
No matter the user I try, I keep getting this error from Digital Ocean PostgreSQL managed database. It uses the correct URL and everything. So at this point I'm confused why my database would return this to my Spring ...
0
•
•
By
neyqdev
DigitalOcean Managed PostgreSQL Database
PostgreSQL
Java
-
Question
I have a nodejs app that I'm migrating to digitalocean. I have been getting the same error since Friday.
I have tried all solutions I've seen online but none seems to help. e.g adding droplet ip to trusted sources. I...
0
•
•
By
busingescott
DigitalOcean Managed PostgreSQL Database
-
Question
I logged into the Digital Ocean console today to find that a notification saying that one of my managed databases is running low on disk space.
I tried to go increase the disk size, but the only option I can find that...
1
•
•
By
finnn
DigitalOcean Managed PostgreSQL Database
-
Question
Hi,
I've been trying to migrate a Nextcloud db instance running as a pod in Digital Ocean Kubernetes to Digital Ocean's managed database service unsuccessfully. I've been able to communicate and migrate the data from ...
0
•
•
By
clvx
DigitalOcean Managed Kubernetes
DigitalOcean Managed PostgreSQL Database
-
Question
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...
2
•
•
By
l0qii
DigitalOcean Managed PostgreSQL Database