Install the pgAdmin web-based GUI to simplify your PostgreSQL database management tasks. We will use the APT package manager to install it:

       
1. Run these commands individually to add the pgAdmin official repository:
       

curl -fsSL https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/pgadmin.gpg

       

sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list'

       
2. Update the package lists to synchronize the repository.
       

sudo apt update

       
3. Run the following command to install pgAdmin:
       

sudo apt install pgadmin4

       
4. After the GUI setup finishes, initiate the primary pgAdmin configuration with this command:
       

sudo /usr/pgadmin4/bin/setup-web.sh

       

Enter your email address and password.

       
       
5. To access the pgAdmin web-based interface, enter the following in your web browser’s address bar:
       

http://185.185.185.185/pgadmin4

       

Replace the IP address with your VPS’. Then, enter your email address and password. Click Login to enter the main pgAdmin dashboard.

       
       
6. To connect PostgreSQL, select Add New Server and proceed with the configuration process.