1.1.3 How to use pgAdmin

Owned by CIMON (Unlicensed)
Last updated: Apr 12, 2023
2 min read

Verifying a PostgreSQL Database with pgAdmin 4

pgAdmin 4 is an open source administration tool for managing PostgreSQL databases. It allows you to easily manage PostgreSQL databases, run SQL queries, and search and modify database objects. pgAdmin 4 also provides dashboards that allow users to visually explore their data.

 

You can download the pgAdmin 4 program from the following URL path.

URL: https://www.pgadmin.org/download/

(1) Create Server

After running the program, right-click [Servers] in the left Browser menu and click [Register]-[Server] to add it.

(2) Setting server

On the [General] tab, set the name of the server to whatever you want.

On the [Connection] tab, enter the IP, port, DB name, Username, and Password of the database you want to connect to, and click Save.

(3) Verifying Database

Click the server node you set up and check that the database is connected.

  • Default Database cimon_scada is set as the default during installation and should not be deleted.

  • Log in with an administrator account Name and password are set during the UltimateAccess installation process, so be careful not to forget them.

Â