Managing PostgreSQL database via pgAdmin

The pgAdmin is the most popular open-source administration and development platform for PostgreSQL. pgAdmin is a powerful tool to manage PostgreSQL.

1. Locate your target deployment

Log in to the Control Panel and locate your target deployment on the Home page or the My Applications page.

2.Get connection string information

Click the "Manage" button on the Home page or the My Applications page to go to the Overview page.

Go to the Connection Information section to get the PostgreSQL shell connection string.

3.Connect to databases using pgAdmin

Download PgAdmin tool at https://www.pgadmin.org/download/

Start the PgAdmin tool and set up a new database connection as the screenshot.

Fill in the requested information to connect the database.

General name – The name that will be shown in pgAdmin (Does not affect connection)

Server group – Select Servers

Connect now – Enable it

Hostname/address – The IP address or hostname for the PostgreSQL server

Port – Port information is defined in the control panel

Maintenance database- The database name that you want to connect

Username – The database user

Password– Enter your PostgreSQL database's password and save it

4. Edit and manage your database

Click on the created connection to connect to your database, and now you are ready to manage your database as you like.

Copyright © 2019 Cloud Clusters Inc. all right reserved,powered by GitbookRevised on 05/31/2021

results matching ""

    No results matching ""