How to Install pgAdmin4 on Debian 9
Step 1 – Enable Apt Repository
First, you need to import PostgreSQL packages signing key on your system. Use the below command to import the key. Now add PostgreSQL apt repository in your system as per your operating system. These are suggested on official PostgreSQL website using following command.
Step 2 – Install PostgreSQL on Debian 9
At this stage, you have successfully added PostgreSQL official repository in your system. Now update the repository list. After that install Latest PostgreSQL Server in our Ubuntu system using following commands.
Step 3 – Connect to PostgreSQL
After installing the PostgreSQL database server by default, it creates a user ‘postgres’ with role ‘postgres’. It also creates a system account with the same name ‘postgres’. So to connect to postgres server, login to your system as user postgres and connect database. Now you are logged in to PostgreSQL database server. To check login info use following command from database command prompt. To disconnect from PostgreSQL database command prompt just type below command and press enter. It will return you back to Debian command prompt.
Step 4 – Conclusion
Your PostgreSQL installation has been completed successfully on your Debian 9 system. Let’s move to pgAdmin4 installation on Debian 9 systems.
title: “How To Install Postgresql 11 On Debian 9 Stretch Tecadmin” ShowToc: true date: “2022-11-13” author: “Claude Abbott”
How to Install PostgreSQL on Ubuntu
Step 1 – Prerequsities
First, you need to import PostgreSQL packages signing key on your system. Use the below command to import the key. Now add PostgreSQL apt repository in your system as per your operating system. These are suggested on official PostgreSQL website using following command.
Step 2 – Install PostgreSQL on Debian 8
At this stage, you have successfully added PostgreSQL official repository in your system. Now update the repository list. After that install Latest PostgreSQL Server in our Ubuntu system using following commands.
Step 3 – Connect to PostgreSQL
After installing the PostgreSQL database server by default, it creates a user ‘postgres’ with role ‘postgres’. It also creates a system account with the same name ‘postgres’. So to connect to postgres server, login to your system as user postgres and connect database. Now you are logged in to PostgreSQL database server. To check login info use following command from database command prompt. To disconnect from PostgreSQL database command prompt just type below command and press enter. It will return you back to Debian command prompt. Your PostgreSQL installation has been completed successfully. Let’s move to phpPgAdmin installation of Ubuntu systems.
