Thursday, March 10, 2022

how to Install pgadmin 4 in ubuntu

  • PostgreSQL is an open source relational database that supports both SQL (relational) and JSON (non-relational) querying. It is a highly stable database management system.
    postgresql is used as a primary database for many web applications as well as mobile and analytics applications.

  • Postgres Default port is 5432

  • PGAdmin is a web-based GUI tool used to interact with the Postgres database sessions, both locally and remote servers as well. You can use PGAdmin to perform any sort of database administration required for a Postgres database.

Step 1) Setup the repository
  • Install the public key for the repository
$ sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add


Step 2) 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'


Step 3) Install pgAdmin GUI Tool

  • install for both desktop and web modes
$ sudo apt install pgadmin4


No comments:

Post a Comment

testing