pgAdmin

pgAdmin is Web-based GUI tool for PostgreSQL, used for Database Management Tools . pgAdmin is a popular and feature rich Open Source administration and development platform for PostgreSQL, the advanced Open Source database in the world.

Prepare

When referring to this document to use pgAdmin, please read and ensure the following points:

• This application is installed by Websoft9 console.

• The purpose of this application complies with the PostgreSQL open source license agreement.

• Configure the domain name or server security group opens external network ports for application access.

Getting started

Initial setup

Before using pgAdmin, if you do not have PostgreSQL, you can install it through the App Store in the Websoft9 console

Login to pgAdmin to connect to the database

When completed installation of pgAdmin at Websoft9 Console, get the applicaiton's Overview and Access information from My Apps

1. Local computer browser login page, enter pgAdmin

2. After logining successfully, enter the console

3. Connect to a PostgreSQL database

Database management

• Servers > Create > Database, create a database
• Servers > Create > Login/Group Role, to create a user (a PostgreSQL user)

Configuration options

• pgAdmin Client: Windows Download
• Backup(✅)

Administer

Troubleshooting