{"id":10044,"date":"2021-09-20T13:09:48","date_gmt":"2021-09-20T13:09:48","guid":{"rendered":"https:\/\/linuxways.net\/?p=10044"},"modified":"2021-09-20T13:09:48","modified_gmt":"2021-09-20T13:09:48","slug":"install-postgresql-13-on-debian-11","status":"publish","type":"post","link":"https:\/\/linuxways.net\/de\/debian\/install-postgresql-13-on-debian-11\/","title":{"rendered":"Install PostgreSQL 13 on Debian 11"},"content":{"rendered":"

PostgreSQL<\/a> is a popular household name amongst database administrators and developers. It is a powerful and opensource Relational Database Management System ( RDBMS ) that leverages the SQL query language to create and manipulate databases. With over 30 years of active development, PostgreSQL is widely used as a database for numerous mobile and web applications. Some of the notable Tech giants that use PostgreSQL include Instagram, Uber, spotify, and Reddit.<\/p>\n

PostgreSQL 13 is the current stable version of PostgreSQL. It ships with new features including incremental sorting, parallel vacuuming and optimizations such as better data management for big or small workloads and security enhancements.<\/p>\n

In this walkthrough, we explore the installation of PostgreSQL 13 on Debian 11 . You might also consider checking out this guide on how to install PostgreSQL 13 on Rocky Linux 8<\/a>.<\/p>\n

Prerequisites<\/strong><\/h2>\n

To get started, ensure you have an Debian 11 server instance with SSH access and a sudo user already configured for executing privileged tasks.<\/p>\n

Step 1: Install PostgreSQL 13<\/strong><\/h2>\n

Thankfully, the latest version of PostgreSQL – PostgreSQL 13 – is hosted on Debian repository. You can confirm this as shown in the command below.<\/p>\n

$ apt-cache postgresql<\/strong><\/pre>\n
<\/p>\n
Therefore, to install PostgreSQL 13, first update Debian 11 package index.<\/p>\n
$ sudo apt update<\/strong><\/pre>\n
<\/p>\n
Thereafter, use the APT package manager to install PostgreSQL 13 alongside other additional packages and dependencies:<\/p>\n
$ sudo apt install postgresql postgresql-contrib<\/strong><\/pre>\n
This installs PostgreSQL, and additional software packages and their dependencies.<\/p>\n
<\/p>\n
Once done, head over to the next step.<\/p>\n
Step 2: Confirm the status of PostgreSQL 13<\/strong><\/h2>\n
The PostgreSQL database service should start automatically without intervention. Verify this with the command:<\/p>\n
$ sudo systemctl status postgresql@13-main.service<\/strong><\/pre>\n
<\/p>\n
Alternatively, you can run the following command to confirm its status. The output will provide the status of the server including the PID ( Process ID ).<\/p>\n
$ sudo pg_ctlcluster 13 main status<\/strong><\/pre>\n
pg_ctlcluster 13<\/p>\n
 main status<\/p>\n
If you are curious enough, you can check the version installed as follows:<\/p>\n
$ \/usr\/lib\/postgresql\/bin\/postgres -V<\/strong><\/pre>\n
<\/p>\n
Step 3: Starting and enabling PostgreSQL 13<\/strong><\/h2>\n
If by any chance PostgreSQL is not running or is inactive, you can start it using the command:<\/p>\n
$ sudo systemctl start postgresql@13-main.service<\/strong><\/pre>\n
To make PostgreSQL automatically start every time the system is powered on or rebooted, enable it as follows.<\/p>\n
$ sudo systemctl enable postgresql@13-main.service<\/strong><\/pre>\n
<\/p>\n
Step 4: Accessing PostgreSQL 13 database server<\/strong><\/h2>\n
When PostgreSQL is installed, a new user called postgres <\/strong>is created by default. You can confirm this by having a peek at the \/etc\/passwd <\/strong>file which stores users\u2019 information such as UID and GID,<\/p>\n
$ cat \/etc\/passwd | grep -i postgres<\/strong><\/pre>\n
To make matters simpler, you can invoke the id <\/strong>command<\/p>\n
$ id postgres<\/strong><\/pre>\n
<\/p>\n
To connect to the database, switch to the postgres <\/strong>user as shown.<\/p>\n
$ sudo su - postgres<\/strong><\/pre>\n
Then access the PostgreSQL interactive shell as shown<\/p>\n
$ psql<\/strong><\/pre>\n
<\/strong><\/p>\n
The interactive shell allows you to run SQL queries and perform all matter of SQL queries. Run the help <\/strong>command to view some command usages<\/p>\n
postgres=# help<\/strong><\/pre>\n
<\/strong><\/p>\n
To exit the shell, simply run:<\/p>\n
# \\q<\/strong><\/pre>\n
Then exit from the postgres<\/strong> user session.<\/p>\n
$ exit<\/strong><\/pre>\n
Conclusion<\/strong><\/h2>\n
This closes the curtain on this guide. We have walked you through a step-by-step procedure of installing PostgreSQL 13 on Debian 11 Bulls-Eye.<\/p>","protected":false},"excerpt":{"rendered":"
PostgreSQL is a popular household name amongst database administrators and developers. It is a powerful and opensource Relational Database Management System ( RDBMS ) that leverages the SQL…<\/p>","protected":false},"author":1,"featured_media":10300,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[521,415],"class_list":["post-10044","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-debian","tag-debian-11","tag-postgresql-13"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/10044","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/comments?post=10044"}],"version-history":[{"count":0,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/10044\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/10300"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=10044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=10044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=10044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}