-
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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