Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the js_composer domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/holhol2/public_html/wp-includes/functions.php on line 6121

How to Install PostgreSQL on Debian 11 / Debian 10 | Holhol24

By holhol24 | September 16, 2021
How to Install PostgreSQL on Debian 11 / Debian 10 | ITzGeek

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.

holhol24

I am a Linux server pro admin and enthusiast, an upcoming web developer, junior php developer. I am currently a content creator for Holhol24, I love to play with Linux and all other distributions of it. I loves working with computers and strongly believes in sharing knowledge. Follow me For more insight into what is happening in Tech.

Advertisement Share: Facebook Twitter WhatsApp

Deprecated: File Theme without comments.php is deprecated since version 3.0.0 with no alternative available. Please include a comments.php template in your theme. in /home/holhol2/public_html/wp-includes/functions.php on line 6121

Leave a Reply

Your email address will not be published. Required fields are marked *