Now that you have a brief understanding of what a database is, you know the history of PostgreSQL, and are familiar with some of the advantages of using PostgreSQL, you are ready to start using it. We will begin by learning how to install it in our operating system. We will also be using the DBeaver client software to help us get off the ground quickly.
For reference, these are the topics we will be covering in the entire database tutorial:
- Postgres Overview
- Install PostgreSQL(this article)
- Access PostgreSQL Using PSQL
- Access PostgreSQL Using DBeaver
- How to Secure PostgreSQL
- Getting Started With PostgreSQL
- Sample Flask Project Using PostgreSQL
In this article, we will focus on installing PostgreSQL, creating a connection to it and optionally know how to uninstall it.
- Install PostgreSQL in Linux Using the Terminal
- Create Connection to PostgreSQL
- Uninstall PostgreSQL in Linux Using the Terminal
Most Linux distributions such as Debian and Ubuntu have PostgreSQL integrated with their package environments by default. However, Ubuntu "snapshots" a specific version of PostgreSQL that is then supported throughout the lifetime of that Ubuntu version. Other versions of PostgreSQL are available through the PostgreSQL apt repository. It is recommended that you install PostgreSQL this way since it ensures a proper integration with the operating system, including automatic patching and other management functionality.
If you try to search for an available version of PostgreSQL after a fresh install of Ubuntu by running psql -V, you will notice that the command psql will not be found. You will be told that it can be installed by running:
sudo apt install postgresql-client-common
When installed, running psql -V would show this outcome:
psql (PostgreSQL) 14.4 (Ubuntu 14.4-1.pgdg20.04+1)Install and build from source by visiting the Linux downloads (Ubuntu) for more information.
User privilege and privilege access management (PAM) is a serious security concept when working with databases. What privilege access does is to empower organizations to reduce the threat that may come due to data breaches. For example, a business might have two employees with administrator access to a database. Only these users have the authority to work with the database and can delete or setup objects in a database.
From the PostgreSQL Overview article, you may have noticed that one of the advantages of using PostgreSQL is its ability to handle access control through roles and privileges.
There are two ways we can access PostgreSQL. Check them using the links below:
You can choose one over the other based on your personal preferrance, but it is good to know of both ways.
For whatever reason, if you wish to uninstall PostgreSQL from your system, you can do the following:
$ dpkg -l | grep postgres
# Output
ii pgdg-keyring 2018.2 all keyring for apt.postgresql.org
ii postgresql 14+242.pgdg20.04+1 all object-relational SQL database (supported version)
ii postgresql-14 14.4-1.pgdg20.04+1 amd64 The World's Most Advanced Open Source Relational Database
ii postgresql-client-14 14.4-1.pgdg20.04+1 amd64 front-end programs for PostgreSQL 14
ii postgresql-client-common 241.pgdg20.04+1 all manager for multiple PostgreSQL client versions
ii postgresql-common 241.pgdg20.04+1 all PostgreSQL database-cluster managerThe command above will list all dependant packages of postgres (or postgresql). Then, you can uninstall these packages individually:
$ sudo apt --purge remove package_name package_namepurge completely erases traces of the configuration files of a program from the system. It is particularly useful when you want to "start all over again" with an application because you messed up the configuration. See this discussion on StackExchange (askubuntu).
Now that everything has been uninstalled, you can verify the uninstallation process by running:
$ psql -V