Skip to content

Latest commit

 

History

History
64 lines (42 loc) · 1.25 KB

README.md

File metadata and controls

64 lines (42 loc) · 1.25 KB

Installation Guide for PostgreSQL

Sl No Version Operating System
1 latest(v4.2.1) Debian / Ubuntu (all v<20.10)

  • Installation of PostgreSQL(13.x.x) Ubuntu/Debian

  1. Update the system software packages using the following apt command.
  sudo apt update
  1. Setup the repository & install the public key for the repository (if not done previously)
sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add
  1. Create the repository configuration file
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 && apt update'
  1. Install pgAdmin, PostgreSQL UI - Client
sudo apt install pgadmin4

These clients are available as desktop-application, as well as web-mode.

# Install for desktop mode only:
sudo apt install pgadmin4-desktop
# Install for web mode only: 
sudo apt install pgadmin4-web
  1. If you have installed the web-mode pgadmin; configure the webserver
sudo /usr/pgadmin4/bin/setup-web.sh
  1. To check if PostgreSQL has been installed, check using the following command
psql --version