Step 3: Starting and enabling PostgreSQL 13 If you are curious enough, you can check the version installed as follows: $ /usr/lib/postgresql/bin/postgres -V The output will provide the status of the server including the PID ( Process ID ). Verify this with the command: $ sudo systemctl status Īlternatively, you can run the following command to confirm its status. The PostgreSQL database service should start automatically without intervention. Step 2: Confirm the status of PostgreSQL 13 This installs PostgreSQL, and additional software packages and their dependencies. Thereafter, use the APT package manager to install PostgreSQL 13 alongside other additional packages and dependencies: $ sudo apt install postgresql postgresql-contrib Therefore, to install PostgreSQL 13, first update Debian 11 package index. You can confirm this as shown in the command below. Thankfully, the latest version of PostgreSQL – PostgreSQL 13 – is hosted on Debian repository. To get started, ensure you have an Debian 11 server instance with SSH access and a sudo user already configured for executing privileged tasks.
#POSTGRESQL 13 HOW TO#
You might also consider checking out this guide on how to install PostgreSQL 13 on Rocky Linux 8. In this walkthrough, we explore the installation of PostgreSQL 13 on Debian 11. 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. PostgreSQL 13 is the current stable version of PostgreSQL.
Some of the notable Tech giants that use PostgreSQL include Instagram, Uber, spotify, and Reddit. With over 30 years of active development, PostgreSQL is widely used as a database for numerous mobile and web applications. It is a powerful and opensource Relational Database Management System ( RDBMS ) that leverages the SQL query language to create and manipulate databases. PostgreSQL is a popular household name amongst database administrators and developers.
0 kommentar(er)
