Install PostgreSQL on Debian 12.11

Install PostgreSQL on Debian 12.11 to set up a secure, reliable, and scalable database. Our PostgreSQL Support team is ready to assist you.

Step-by-Step Guide to Install PostgreSQL on Debian 12.11

A robust, open-source database system known for its dependability and efficiency is PostgreSQL. Its installation on Debian 12.11 ensures a stable and safe environment for your projects. You can securely and effectively handle data with the right setup. This article covers each step to help you install and set up PostgreSQL with simplicity.

What is PostgreSQL on Debian 12.11?

Installing PostgreSQL on Debian 12.11 entails configuring and executing the PostgreSQL database on the Bookworm operating system. A robust, open-source database system known for its sophisticated features and dependability is PostgreSQL. It enables users to expand its capabilities as required and fully supports SQL standards.

Prerequisites

Prior to installing PostgreSQL on Debian 12.11, your server must be ready. Start by setting up a Debian 12 cloud compute instance on Vultr and gaining SSH access to it. For added protection, create a non-root user with sudo rights and switch to that account. Finally, before beginning the installation, update the system to ensure that all packages are current.

 

Step 1: Update System Packages

Verify that your system is updated. Launch your terminal and type:

sudo apt update && sudo apt upgrade -y

Step 2: Install PostgreSQL on Debian 12

Install PostgreSQL by executing the following command:

sudo apt install postgresql postgresql-contrib -y

Check out our expert guide to setup PostgreSQL on Linux in Vesta for a smooth installation.

Step 3: Start and Enable PostgreSQL Service

Launch PostgreSQL and set it to start automatically:

sudo systemctl start postgresql

sudo systemctl enable postgresql

Step 4: Secure the Default PostgreSQL User

To create a password, switch to the PostgreSQL user account that is set by default:

sudo -i -u postgres

psql

Inside the PostgreSQL prompt, set a strong password:

\password postgres

Exit the prompt:

\q

exit

Step 5: Create a New Database in PostgreSQL

Login as the postgres user:

sudo -i -u postgres

Create a new database and a new user (replace yourdbname and yourdbuser):

createdb yourdbname

createuser -P yourdbuser

Grant privileges:

psql

GRANT ALL PRIVILEGES ON DATABASE yourdbname TO yourdbuser;

\q

exit

Step 6: Configure PostgreSQL Settings

Modify the configuration files if you require additional custom settings or external connections:

sudo nano /etc/postgresql/14/main/postgresql.conf

sudo nano /etc/postgresql/14/main/pg_hba.conf

Restart PostgreSQL after making changes:

sudo systemctl restart postgresql

Want to update your PostgreSQL credentials? Read our guide on changing passwords via CLI.

[Need assistance with a different issue? Our team is available 24/7.]

Conclusion

In conclusion, when you install PostgreSQL on Debian 12.11, you set up a secure, scalable, and reliable database system. It includes sophisticated functionality and ensures seamless data handling when configured properly. For small projects as well as enterprise-level applications, this makes it a good option.

In brief, our Support Experts demonstrated how to fix the “554 5.7.1 : Relay access denied” error.