Online Documentation for SQL Management Studio for PostgreSQL

Using services


SQL Studio's integrated features provide an easy way to run all native PostgreSQL services that are intended for database maintenance. The following services and server tools are available:

 

 

Database Management - Services

 

 

To run a service, click its icon or caption on the Desktop Panel and follow the steps of the Wizard. If necessary, you can click the Arrow-down button to open the menu allowing you to specify a template and run the wizard with this template.

 

To manage configuration files (templates), use the corresponding Manage templates link. In this case you will be redirected to the Template Management section of SQL Studio.

 

Analyze Tables

Collects statistics about the contents of database tables.

 

Vacuum Tables

Reclaims storage occupied by deleted tuples.

 

Reindex

Rebuilds corrupted indexes.

 

Backup Database

Creates backup copies of your PostgreSQL databases.

 

Restore Database

Restores PostgreSQL databases from previously created backups.

 

Backup Cluster

Creates a backup of a running database cluster.

 

Verify Backup

Checks the integrity of a database cluster backup.

 

Combine Incremental Backups

Reconstructs a full backup from an incremental backup and dependent backups.