PostgreSQL (regularly abbreviated as Postgres) is an object-relational database control gadget (ORDBMS) emphasizing extensibility and requirements compliance.
It has greater than 30 years of lively building and a confirmed structure that has earned it a powerful recognition for reliability, knowledge integrity, and function.
PostgreSQL is launched underneath the PostgreSQL License and is to be had for Linux, Microsoft Windows, FreeBSD, OpenBSD, and macOS.
In this submit, we can see learn how to set up PostgreSQL on Debian 11 / Debian 10.
Add PostgreSQL repository
PostgreSQL publishes applications for Debian working gadget thru their devoted repository, and the applications of their repository are brisker than the ones to be had within the OS repository.
First, replace the repository index the use of the apt command
sudo apt replace
Then, set up the HTTPS reinforce for apt to get applications from the web.
sudo apt set up -y curl apt-transport-https
Now, import the PostgreSQL signing key.
# Debian 11 curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo gpg --dearmor -o /usr/percentage/keyrings/postgresql-keyring.gpg # Debian 10 curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key upload -
Finally, upload the PostgreSQL repository knowledge to the gadget with the under command.
# Debian 11 echo "deb [signed-by=/usr/share/keyrings/postgresql-keyring.gpg] http://apt.postgresql.org/pub/repos/apt/ bullseye-pgdg main" | sudo tee /and so forth/apt/resources.record.d/postgresql.record # Debian 10 echo "deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main" | sudo tee /and so forth/apt/resources.record.d/postgresql.record
Install PostgreSQL on Debian
Once you’ve gotten added the PostgreSQL repository, run the next command to replace the repository index.
sudo apt replace
Then, set up PostgreSQL the use of the under command in line with the PostgreSQL model you wish to have to put in.
# PostgreSQL 13 sudo apt set up -y postgresql-13 # PostgreSQL 12 sudo apt set up -y postgresql-12
By now, the PostgreSQL provider shall be up and operating. You can test the standing of the provider with the under command.
sudo systemctl standing postgresql
Output:
● postgresql.provider - PostgreSQL RDBMS Loaded: loaded (/lib/systemd/gadget/postgresql.provider; enabled; supplier preset: enabled) Active: lively (exited) since Wed 2021-09-15 14:19:30 CDT; 42s in the past Main PID: 3759 (code=exited, standing=0/SUCCESS) Tasks: 0 (restrict: 2343) Memory: 0B CGroup: /gadget.slice/postgresql.provider Sep 15 14:19:30 debian.holhol24.native systemd[1]: Starting PostgreSQL RDBMS... Sep 15 14:19:30 debian.holhol24.native systemd[1]: Started PostgreSQL RDBMS.
Configure PostgreSQL Server
By default, PostgreSQL listens at the localhost (127.0.0.1) which you would possibly not at all times need as exterior programs would possibly want to connect with the database. So, we can configure PostgreSQL to hear the gadget IP deal with.
# PostgreSQL 13 sudo nano /and so forth/postgresql/13/major/postgresql.conf # PostgreSQL 12 sudo nano /and so forth/postgresql/12/major/postgresql.conf
Set the listen_addresses to * or
listen_addresses = '192.168.0.10'
Restart PostgreSQL provider.
sudo systemctl restart postgresql
You can now use the netstat command to substantiate if PostgreSQL listening on port 5432 or now not.
sudo netstat -antup | grep 5432
Output:
tcp 0 0 192.168.0.10:5432 0.0.0.0:* LISTEN 5265/postgres
READ: netstat command now not discovered on Debian – Quick Fix
Access PostgreSQL
To set up the PostgreSQL database, it is important to log in as a postgres (Linux consumer) after which must get entry to the database shell the use of the psql command.
sudo -u postgres psql
Output:
postgres@server:~$ psql
psql (13.4 (Debian 13.4-1.pgdg100+1))
Type "help" for lend a hand.
postgres=#
On psql shell, run the under command to modify the postgres consumer (Database admin password.
postgres=# password
OR
postgres=# password postgres
Conclusion
That’s All. I am hoping you’ve gotten discovered learn how to set up PostgreSQL on Debian 11 / Debian 10.
