Navicat's Backup feature allows you to backup all tables and records of a PostgreSQL database. You can also restore your backup by using Restore Backup function. If you wish to transfer your data between two servers, you can use Data Transfer function to achieve it.

Creating a new Backup

1. In the Main Window , click Backup tab
   
2. Select the connection and database that you want to backup the tables.
   
3. To create a new backup, click New Backup button in the Database Window
   
4. Click the Start button in the Backup window.

Restore a Backup
Warning: For restoring a backup, you must have Create, Drop and Insert Privileges. All the existing data and tables will be replaced by the backup.

Restore function will firstly drop all your existing tables of the database. Afterwards, it would create the tables according to your backup. Next, it would insert the data to your database according to your backup.

1. Select the connection and database that you want to restore.
   
2. Click Backup tab in the main window.
   
3. Select a backup that you want to restore and click Restore Backup button.
   
4. Click the Start button in the Restore window.

Delete a Backup

1. Select the connection and database that contain the backup you want to delete.
   
2. Click Backup tab in the main window.
   
3. Select the backup you want to delete.
   
4. Click Delete Backup button.

Extract SQL from a Backup

1. Select the connection and database that contain the backup you want to extract.
   
2. Click the Backup tab in the main window.
   
3. Select the backup you want to extract.
   
4. Click Extract SQL from the Backup menu.