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.
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 all commands for the PostgreSQL snap: https://discourse.charmhub.io/t/17269
Read more about database storage: https://discourse.charmhub.io/t/17684
Thank you for your report. Information you provided will help us investigate further.
There was an error while sending your report. Please try again later.
You are about to open
Do you wish to proceed?
Snaps are applications packaged with all their dependencies to run on all popular Linux distributions from a single build. They update automatically and roll back gracefully.
Snaps are discoverable and installable from the Snap Store, an app store with an audience of millions.
Snap can be installed from the command line. Open the Konsole terminal and enter the following:
sudo apt update
sudo apt install snapd
To install PostgreSQL, simply use the following command:
sudo snap install postgresql
Browse and find snaps from the convenience of your desktop using the snap store snap.
Interested to find out more about snaps? Want to publish your own application? Visit snapcraft.io now.