PostgreSQL¶

PostgreSQL is an advanced Object-Relational database management system (DBMS). The base postgresql package contains the client programs that you’ll need to access a PostgreSQL DBMS server, as well as HTML documentation for the whole system. These client programs can be located on the same machine as the PostgreSQL server, or on a remote machine that accesses a PostgreSQL server over a network connection.

Quickstart¶

Start an instance with 1-Click, or optionally using your cloud provider’s web/console
Have just a little patience: it does take a couple of minutes for all the background services to start up in your instance. If you get connection refused or site error messages - just wait a moment
SSH into your instance and then connect to the PostgreSQL service:

$ psql -U postgres

Type your instance id as the password when prompted.

Your PostgreSQL is now fully configured and ready to be used with your application stack. If for example, you have our Airflow - edit the sql_alchemy_conn variable to postgresql://<PG_USER>:<PG_PASSWORD>@<Instance_Public_IP_DNS>:5432/<PG_DB> in /etc/airflow/airflow.cfg.

Monitoring¶

We are a Grafana shop and have a PostgreSQL exporter for PostgreSQL. You may import the dashboard from 14114