PgSQL

Management Local and remote PostgreSQL

PgSQL Overview

Function	Describe
Add DB	Add database to local PostgreSQL or remote server PostgreSQL
Root Password	Change root password of local PostgreSQL
Remote DB	Add or manage databases on remote servers
Sync all	Synchronize the database list of aaPanel to local PostgreSQL
Get DB from server	Obtain the database list from the local PostgreSQL or remote server and synchronize it to aaPanel
Database name	Display current database name
Username	Display current username
Password	View, Copy the password of the current database
Backup	Displays the number of backups, click on it to display Backup, Download, Restore, Delete the current database file
Import	Upload, Select files and import them into the current database
Position	Displays the physical storage location of the current database
Note	Display the note of the current database
CHG PW	Change the password of the current database
Delete	Delete current database, Tip: Please make a backup before deleting

Add DB

Add a database to local PostgreSQL or remote server PostgreSQL

Function	Example	Describe
Database name	Ctest	PostgreSQL Database name
Username	Ctest	Database username
Password	nmEdhbaB5GbpnpF5	Database password
Add to	Local server	Database storage server: Local server, Remote server

Root Password

• View the local PostgreSQL root password
• Modify the local PostgreSQL root password

Remote DB

• Add and Manage Remote DB :

1. By default aaPanel PostgreSQL does not allow remote access.

2. The remote server system firewall and the server provider's security group need to open the PostgreSQL port.

Sync all

• Synchronize aaPanel database list to local PostgreSQL

Get DB from server

Tip: Database password cannot be synchronized

• Obtain the database list from local PostgreSQL and synchronize it to aaPanel
• Obtain the database list from the remote PostgreSQL and synchronize it to aaPanel.

Backup

View, restore, backup, delete, download backup files of the specified database

• Backup: Backup the current database

• Repair: Restore the current database. Note that this operation will overwrite the current database. Please backup first before performing this operation.

• Download: Download the backup file of the current database

• Delete: Delete the backup file of the current database

Import

Upload or select files to import into the current database

• Upload from local: Upload files from local to import to the current database

• Import: Restore the current database. Note that this operation will overwrite the current database. Please backup first before performing this operation.

• Delete: Delete file

CHG PW

View and modify the password of the specified database in batches

Batch operation

• Sync to Server: Synchronize the specified database to PostgreSQL

• DB backup: Batch backup database

• Delete database: Delete database in batches, Tip: Please make a backup before deleting

Feedback or Suggestions

If you encounter problems or suggestions during use, please contact us through the following methods:

• (Please describe in detail or provide screenshots)

1. Forum: https://www.aapanel.com/forum
2. Email: [email protected]