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. 14/edge), and paste the command in your terminal.

Use the snap:

Once installed, PostgreSQL will start automatically, to login:

postgresql.psql -U postgres -h localhost

it is highly recommended to set a new password (in the Postgres console):

\password postgres

Tip: For convenience, you can create an alias using snapd's alias feature:

sudo snap alias postgresql.psql psql