As of this writing, DigitalOcean offers versions 10 through 13 for its Managed PostgreSQL Databases. Some managed database providers offer various options for which version of PostgreSQL you want your database to use. You can install psql by itself by installing the postgresql-client package with APT, but if you install it from the default Ubuntu 18.04 repositories it will install version 10 of psql, while the latest major version of PostgreSQL is version 13. It’s open-source, maintained by the PostgreSQL Development Group, and is typically included when you install the PostgreSQL server.

To connect to a managed PostgreSQL database, you can use psql, the standard command line client for Postgres. Connecting to a Managed PostgreSQL Database Once you have these prerequisites in place, jump to whichever section aligns with your Database Management System (DBMS). To provision a DigitalOcean Managed Database, review our documentation for the DBMS of your choice: This tutorial provides instructions on how to connect to a variety of database management systems, specifically PostgreSQL, MySQL, Redis, and MongoDB. To set this up, follow our Initial Server Setup Guide for Ubuntu 18.04.

This server should have a non-root user with administrative privileges and a firewall configured with ufw. Access to a server running Ubuntu 18.04.To follow the instructions detailed in this guide, you will need: If, however, you run into issues connecting to a database provisioned from another provider, you should consult their documentation for help. Note: The instructions outlined in this guide were tested with DigitalOcean Managed Databases, but they should generally work for managed databases from any cloud provider.

Tableplus tutorial