DigitalOcean Managed PostgreSQL Database

DigitalOcean Managed PostgreSQL Database subscription active
You will receive email notifications for new publications on DigitalOcean Managed PostgreSQL Database.
30 Results
  • Question

    Ho to create database cluster with trusted sources with CLI or terraform ?

    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

    How many databases can I create for $ 15?

    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

    How much database space remains available?

    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

    Suggestions: alert policies within managed databases that match the metrics offered

    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

    Is it possible to use a VPN IPSEC Site-to-Site connection to a Digital Ocean's PostgreSQL

    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

    Local hot standby slave that can connect to a remote master (managed database)?

    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

    How can I reset the postgres "Query statistics" section?

    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

    How can I add the CA certificate of my postgres cluster to a docker container?

    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

    How to connect to remote database on digital Ocean with pycharm ?

    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...
    0 By devjo DigitalOcean Managed PostgreSQL Database
  • Question

    How do i connect postgresql db from visual studio 2019 ?

    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

    Is there PostGis support for PostgreSQL?

    Hello, I tried to do create extension postgis; in my managed database, which worked, but when I connect now it says: django.db.utils.OperationalError: could not open extension control file "/usr/share/postgresql/12/e...
    2 By omerc DigitalOcean Managed PostgreSQL Database
  • Question

    Trying to install PostGIS

    The project I created this managed database for requires the postgis extension to be installed. However, the system seems to create the extension under the postgres user (superuser). That seems to cause the following ...
    0 By ilauzirika DigitalOcean Managed PostgreSQL Database
  • Question

    How to solve Too Many Clients issue?

    We constantly keep bumping into Too Many Clients issue on our Managed Postgresql cluster. We are currently using the smallest cluster. When we bump into this issue, we try to run pg_stat_activity and kill some pids th...
    1 By leninmishra DigitalOcean Managed PostgreSQL Database
  • Question

    Users and Roles for DJango App running with Postgres dB in DO droplet

    Hi, I followed both of these document https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-18-04 for setting up our production hosting server but this doesn...
    2 By bengaltiger DigitalOcean Managed PostgreSQL Database
  • Question

    Can not connect to database with psql

    Trying to connect to database with flags, my ip exist in trusted sources, but anyway get this error psql: could not connect to server: Operation timed out Is the server running on host "___________.ondigitalocean...
    1 By fitumapp DigitalOcean Managed PostgreSQL Database
  • Question

    My PostgreSQL Cluster won't deploy.

    The progress bar stopped at a certain point and that's it... I can't cancel it or create a new cluster and that's really sad. Now I'm stuck because your api or system doesn't allow me to cancel or create a second clus...
    1 By damiantoczek DigitalOcean Managed PostgreSQL Database
  • Question

    Can I select the database size?

    The disk size is tied up to each pricing tier, is there an option I can select separate max disk size? For instance, I don't want to go up to 16GB+6vCPU plan because 4GB+2vCPU is enough but I need at least 115 GB of s...
    2 By cubski DigitalOcean Managed PostgreSQL Database
  • Question

    Doadmin permissions for spatial_ref_sys in postgis

    I've created a Managed PostgreSQL Database with the Postgis extension. It creates the spatialrefsys table with the list of supported reference projections for spatial queries. I need to add a new projection to spatial...
    0 By anellaico DigitalOcean Managed PostgreSQL Database
  • Question

    Is there a slow query log for a managed database?

    I want to tune my application and for this I want to see the slow running queries. Is this available for a postgres managed database?
    1 By phoebebright310 DigitalOcean Managed PostgreSQL Database
  • Question

    I am trying to connect django to managed database, i am not able to do.

    After updating the django settings.py default database to correct values. i am able to run makemigrations and migrate command and also create super user. but when i login to the admin it gives me error of "no such tab...
    1 By ranuvijay DigitalOcean Managed PostgreSQL Database