PostgreSQL

PostgreSQL is a powerful, open source object-relational database system. It has more than 20 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

Install the snap

If you are an Ubuntu user, snapd is pre-installed and ready to go on all recent Ubuntu releases. Simply click on the drop-down menu at the upper right-hand corner of this page, select your channel of choice (e.g. 16/stable), and paste the command in your terminal, e.g.:

sudo snap install postgresql

If you are not using Ubuntu, scroll further down this page to find installation instructions for other distributions.

Use the snap

Once installed, PostgreSQL will start automatically. To log in, run:

postgresql.psql -U postgres -h /tmp

It is highly recommended to set a new password in the postgres console:

\password postgres

For convenience, the snap alias psql is pre-created:

psql -U postgres -h /tmp

See more PostgreSQL snap documentation on GitHub: https://github.com/canonical/postgresql-snap/blob/16/edge/docs