Install Postgres Database & pgAdmin4 on Ubuntu 20.04

Photo by Boitumelo Phetla on Unsplash
  • Go to the terminal and update system software packages
  • Install the package of PostgreSQL and it’s contrib files
  • Once the installation done check the status of postgresql

OR

  • If status is active then go to next step and create database using below command
  • To connect the database
  • Now create user
  • Create database
  • Grant role to the users
  • To check whether connection is secure or not for this we need to check pg_hba.conf file
  • Once it is done now install pgadmin4
  • Now install pgadmin packages
  • After installation of pgadmin4 do server setup
server-setup
  • Now play around queries
sql queries

Thank you for reading .Give it try and share your feedback :)

Software Developer | Technical Writer

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store