{"id":2071,"date":"2024-05-26T10:41:55","date_gmt":"2025-06-18T03:43:48","guid":{"rendered":""},"modified":"2025-02-02T00:46:18","modified_gmt":"2025-02-01T23:46:18","slug":"how-to-install-postgresql-on-ubuntu-22-04","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/how-to-install-postgresql-on-ubuntu-22-04\/","title":{"rendered":"Linux VPS & VPS Windows Setup Guide | NetCloud24 PostgreSQL on Ubuntu 22.04"},"content":{"rendered":"

\u00a0<\/p>\n<\/p>\n

\n

\u00a0<\/h1>\n<\/header>\n
\n

PostgreSQL<\/strong> is a powerful, open-source relational database management system (RDBMS) that is highly reliable and provides advanced features for database management. In this guide, we will walk you through the steps to install PostgreSQL on Ubuntu 22.04<\/strong>. Hosting PostgreSQL on a ensures that your database operates efficiently with dedicated resources and scalability through a VPS server<\/strong>.<\/p>\n

Step 1: Update Your VPS Server<\/h2>\n

Before installing PostgreSQL, make sure your VPS server<\/a> is up to date. Run the following commands to update your system:<\/p>\n

sudo apt update && sudo apt upgrade -y<\/code><\/pre>\n
Using a Windows VPS<\/strong> ensures that your PostgreSQL database benefits from dedicated CPU, memory, and storage, leading to better performance and reliability.<\/p>\n
Step 2: Install PostgreSQL<\/h2>\n
PostgreSQL is available in the default Ubuntu repositories, so installation is straightforward. Use the following command to install PostgreSQL:<\/p>\n
sudo apt install postgresql postgresql-contrib -y<\/code><\/pre>\n
This command installs both PostgreSQL and additional useful extensions provided by postgresql-contrib<\/code>.<\/p>\n
Step 3: Start and Enable PostgreSQL<\/h2>\n
After the installation, the PostgreSQL service will start automatically. You can verify its status with this command:<\/p>\n
sudo systemctl status postgresql<\/code><\/pre>\n
To ensure that PostgreSQL starts automatically at boot, run:<\/p>\n
sudo systemctl enable postgresql<\/code><\/pre>\n
Step 4: Configure PostgreSQL<\/h2>\n
By default, PostgreSQL creates a system user named postgres<\/code> for administrative purposes. You can log in to the PostgreSQL prompt using this user:<\/p>\n
sudo -i -u postgres<\/code><\/pre>\n
Once logged in, start the PostgreSQL shell:<\/p>\n
psql<\/code><\/pre>\n
From here, you can execute SQL queries and perform administrative tasks. To exit the PostgreSQL shell, type:<\/p>\n
\\q<\/code><\/pre>\n
Step 5: Create a New Database and User<\/h2>\n
For security and organization, it\u2019s recommended to create a new PostgreSQL user and database instead of using the default postgres<\/code> user. To create a new user and database, log into the PostgreSQL shell and run the following commands:<\/p>\n
\r\nCREATE DATABASE mydatabase;\r\nCREATE USER myuser WITH PASSWORD 'mypassword';\r\nGRANT ALL PRIVILEGES ON DATABASE mydatabase TO myuser;\r\n\\q\r\n<\/code><\/pre>\n
This creates a new user myuser<\/code> with the password mypassword<\/code> and assigns all privileges on mydatabase<\/code> to the user.<\/p>\n
Step 6: Enable Remote Access to PostgreSQL (Optional)<\/h2>\n
By default, PostgreSQL only listens on localhost<\/code>, which means it’s not accessible from remote machines. To allow remote access, edit the PostgreSQL configuration file:<\/p>\n
sudo nano \/etc\/postgresql\/14\/main\/postgresql.conf<\/code><\/pre>\n
Find the line that begins with #listen_addresses = 'localhost'<\/code> and change it to:<\/p>\n
listen_addresses = '*'<\/code><\/pre>\n
Save and close the file. Then, modify the pg_hba.conf<\/code> file to allow external connections:<\/p>\n
sudo nano \/etc\/postgresql\/14\/main\/pg_hba.conf<\/code><\/pre>\n
Add the following line at the end of the file to allow all IP addresses to connect (for production environments, limit the range of allowed IPs):<\/p>\n
host    all             all             0.0.0.0\/0               md5<\/code><\/pre>\n
Restart PostgreSQL to apply the changes:<\/p>\n
sudo systemctl restart postgresql<\/code><\/pre>\n
If you are using a firewall, allow PostgreSQL traffic (port 5432) through the firewall:<\/p>\n
\r\nsudo ufw allow 5432\/tcp\r\nsudo ufw reload\r\n<\/code><\/pre>\n
Step 7: Test PostgreSQL Connection<\/h2>\n
To verify that PostgreSQL is working properly, you can connect to the database using the new user and database you created. Use the following command:<\/p>\n
psql -U myuser -d mydatabase -h 127.0.0.1 -W<\/code><\/pre>\n
Enter the password when prompted, and you will be logged into the PostgreSQL database.<\/p>\n
Step 8: Optimize Your VPS Server for PostgreSQL<\/h2>\n
For high-performance database management, it\u2019s recommended to host PostgreSQL on a . A VPS server<\/strong> offers dedicated resources like CPU, memory, and storage that are essential for handling large databases and high-concurrency connections. As your database grows, you can easily scale the server to ensure that PostgreSQL continues to perform efficiently.<\/p>\n
Conclusion<\/h2>\n
PostgreSQL is a powerful and feature-rich database management system that is easy to set up on Ubuntu 22.04. By hosting your PostgreSQL instance on a , you can ensure that your database operates reliably with dedicated resources, providing excellent performance for your applications.<\/p>\n
For more information about VPS hosting and optimizing your PostgreSQL setup, visit  today.<\/p>\n<\/article>\n