- \n
- Debian 11 Linux operating system with enough space should be running properly on your system.<\/li>\n
- You should have sudo privileges or must be login as a root user for installing the Postgres database on Debian 11 through the command line.<\/li>\n<\/ul>\n
Installation of PostgreSQL on Debian 11<\/h2>\n
Follow the below-mentioned steps to install the Postgres or PostgreSQL14<\/a> on the Debian 11 system:<\/p>\n
Step 1: Install Prerequisites<\/h3>\n
First, update the system repositories list using the \u2018apt\u2019 command.<\/p>\n
$ sudo apt update<\/pre>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2022\/02\/word-image.png\")
<\/p>\nNow, install the recommended HTTPS support packages by executing the below-mentioned command:<\/p>\n
$ sudo apt install -y curl apt-transport-https<\/pre>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2022\/02\/word-image-1.png\")
<\/p>\nStep 2: Add repository of PostgreSQL<\/h3>\n
By default, the PostgreSQL packages are not included in the Debian 11 repository. However, you can install the required packages by adding the PostgreSQL repository to your Debian system. So, download or import the signing key of the PostgreSQL repository by using the following command:<\/p>\n
$ curl -fsSL https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc | sudo gpg --dearmor -o \/usr\/share\/keyrings\/postgresql-keyring.gpg<\/pre>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2022\/02\/word-image-2.png\")
<\/p>\nAdd the PostgreSQL repository to your Debian 11 system by executing the below-mentioned command:<\/p>\n
$ echo \"deb [signed-by=\/usr\/share\/keyrings\/postgresql-keyring.gpg] http:\/\/apt.postgresql.org\/pub\/repos\/apt\/ bullseye-pgdg main\" | sudo tee \/etc\/apt\/sources.list.d\/postgresql.list<\/pre>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2022\/02\/word-image-3.png\")
<\/p>\nStep 3: Install PostgreSQL on Debian 11<\/h3>\n
Once the repository is included, install the PostgreSQL on Debian 11 system. The following syntax will help you to install the desired PostgreSQL version on your system:<\/p>\n
$ sudo apt update<\/pre>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2022\/02\/word-image-4.png\")
<\/p>\n$ sudo apt install -y postgresql-version<\/pre>\n
Here, we are installing the latest PostgreSQL-14 on this system. Therefore, this command will be changed into the following order:<\/p>\n
$ sudo apt install -y postgresql-14<\/pre>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2022\/02\/word-image-5.png\")
<\/p>\nThe \u2018-y\u2019 option will allow you to ignore the confirmation prompt on your terminal window.<\/p>\n
Once the Postgres installation is completed, the service of PostgreSQL will automatically start on your system.<\/p>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2022\/02\/word-image-6.png\")
<\/p>\nVerify the \u2018Active\u2019 or excited status of Postgres service by running the below-mentioned command:<\/p>\n
$ sudo systemctl status postgresql<\/pre>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2022\/02\/word-image-7.png\")
<\/p>\nIf you did not receive the \u2018Active\u2019 status of the PostgreSQL service then, you can enable and start the PostgreSQL services by running the following command:<\/p>\n
$ sudo systemctl enable postgresql<\/pre>\n
$ sudo systemctl start postgresql<\/pre>\n
Once the postgreSQL installation is completed on your system, it creates by default a\u00a0user with the name \u2018Postgres\u2019 that you can find in the \/etc\/passwd file.<\/p>\n
$ cat \/etc\/passwd | grep -i postgres<\/pre>\n
Step 4: PostgreSQL server configurations<\/h3>\n
The postgreSQL listens at the localhost port \u2018127.0.0.1\u2019 by default. but, you change it with your system IP address.<\/p>\n
$ sudo nano \/etc\/postgresql\/14\/main\/postgresql.conf<\/pre>\n
Change the listen_addresses<\/strong> to your <IPAddress><\/strong> or *<\/strong> symbol.<\/p>\n
listen_addresses = 'IP-Address'<\/pre>\n
![\"C:\\Users\\DELL\\OneDrive\\Desktop\\qqq.png\"](\"http:\/\/linuxways.net\/wp-content\/uploads\/2022\/02\/c-users-dell-onedrive-desktop-qqq-png.png\")
<\/p>\nNow, restart the postgreSQL service on your system.<\/p>\n
$ sudo systemctl restart postgresql<\/pre>\n
Step 5: Login into the PostgreSQL database<\/h3>\n
Login as a \u2018postgres\u2019 user to the postgres database by using the below-mentioned command:<\/p>\n
$ sudo -u postgres psql<\/pre>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2022\/02\/word-image-8.png\")
<\/p>\nNow, we can use the PostgreSQL database through the psql commands.<\/p>\n
$ psql<\/pre>\n
Congratulations! We have successfully installed PostgreSQL 14 on the Debian 11 system. Now, you can easily create the postgreSQL databases on your system.<\/p>\n
Conclusion<\/h2>\n
We installed PostgreSQL 14 database on the Debian 11 system. We have seen how to execute various commands to run the PostgreSQL-14 database on the Debian 11 system. The same installation steps you can follow to install the PostgreSQL on Ubuntu<\/a> and its derivatives. You can also download the latest release notes for the installation of PostgreSQL 14 from its official PostgreSQL website<\/a>. Thanks!<\/p>","protected":false},"excerpt":{"rendered":"
PostgreSQL is also known as Postgres, an open-source and powerful objects-based relational database system that is used and combined with many features of SQL language. Using the Postgres…<\/p>","protected":false},"author":1,"featured_media":14793,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[521,887],"class_list":["post-14674","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-debian","tag-debian-11","tag-postgresql-14"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/14674","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=14674"}],"version-history":[{"count":0,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/14674\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/14793"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=14674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=14674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=14674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}