{"id":2735,"date":"2023-03-08T13:06:38","date_gmt":"2022-11-01T18:54:40","guid":{"rendered":""},"modified":"2025-02-02T00:46:19","modified_gmt":"2025-02-01T23:46:19","slug":"how-to-install-postgresql-and-pgadmin-on-ubuntu-22-04","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/how-to-install-postgresql-and-pgadmin-on-ubuntu-22-04\/","title":{"rendered":"Linux VPS & VPS Windows Setup Guide | NetCloud24 PostgreSQL and pgAdmin 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 known for its robustness and flexibility. pgAdmin<\/strong> is a popular, feature-rich management tool for PostgreSQL databases. In this guide, we will walk you through how to install both PostgreSQL and pgAdmin on Ubuntu 22.04<\/strong>. Hosting PostgreSQL on a ensures better performance, scalability, and control over your database using a dedicated VPS server<\/strong>.<\/p>\n

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

Before installing PostgreSQL and pgAdmin, ensure your VPS server<\/a> is up to date. Use the following commands to update your system:<\/p>\n

sudo apt update && sudo apt upgrade -y<\/code><\/pre>\n
Hosting PostgreSQL on a Windows VPS<\/strong> allows you to take advantage of dedicated resources, ensuring your database performs optimally even under high traffic or heavy loads.<\/p>\n
Step 2: Install PostgreSQL<\/h2>\n
PostgreSQL is available in the official Ubuntu repositories, making installation straightforward. Install PostgreSQL by running the following command:<\/p>\n
sudo apt install postgresql postgresql-contrib -y<\/code><\/pre>\n
Once installed, PostgreSQL will start automatically. You can verify the status of the PostgreSQL service using this command:<\/p>\n
sudo systemctl status postgresql<\/code><\/pre>\n
Step 3: Secure PostgreSQL and Set Up a User<\/h2>\n
By default, PostgreSQL creates a user called postgres<\/code> for administrative tasks. Log in as the postgres<\/code> user with the following command:<\/p>\n
sudo -i -u postgres<\/code><\/pre>\n
Now, access the PostgreSQL prompt by running:<\/p>\n
psql<\/code><\/pre>\n
Create a new user and database by running the following commands in the PostgreSQL prompt:<\/p>\n
\r\nCREATE USER myuser WITH PASSWORD 'mypassword';\r\nCREATE DATABASE mydatabase;\r\nGRANT ALL PRIVILEGES ON DATABASE mydatabase TO myuser;\r\n\\q\r\n<\/code><\/pre>\n
This creates a new user myuser<\/code> and a new database mydatabase<\/code>, and grants all privileges on the database to the user.<\/p>\n
Step 4: Install pgAdmin<\/h2>\n
pgAdmin<\/strong> is a popular web-based tool for managing PostgreSQL databases. To install pgAdmin on Ubuntu, first add the pgAdmin repository:<\/p>\n
\r\ncurl https:\/\/www.pgadmin.org\/static\/packages_pgadmin_org.pub | sudo apt-key add -\r\nsudo sh -c 'echo \"deb https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/apt\/jammy pgadmin4 main\" > \/etc\/apt\/sources.list.d\/pgadmin4.list && apt update'\r\n<\/code><\/pre>\n
Next, install pgAdmin with the following command:<\/p>\n
sudo apt install pgadmin4-web -y<\/code><\/pre>\n
Step 5: Configure pgAdmin<\/h2>\n
Once pgAdmin is installed, configure it by running the setup script:<\/p>\n
sudo \/usr\/pgadmin4\/bin\/setup-web.sh<\/code><\/pre>\n
You will be prompted to set up an email and password for the pgAdmin web interface. After that, pgAdmin will be accessible through a web browser. Open your browser and go to http:\/\/your-server-ip\/pgadmin4<\/code> and log in using the credentials you just created.<\/p>\n
Step 6: Connect pgAdmin to PostgreSQL<\/h2>\n
After logging in to the pgAdmin interface, you can connect it to your PostgreSQL database:<\/p>\n