PostgreSQL Plug-in: Configuration

To use PostgreSQL plug-in properly for backing up or restoring data, you will need to create a plug-in configuration specifying the connection to to your databases. The configuration dialog looks like the picture shown:

Configuring PostgreSQL plug-in

Configuration dialog for the PostgreSQL plug-in.

To specify the configuration for the PostgreSQL plug-in, please follow these steps:

  1. Click on the New configuration option during creation of a backup or a restore task. The Settings dialog opens.
  2. Making a new PostgreSQL plug-in configuration
  3. In the Configuration field, enter a name for the configuration created.
  4. In the Host field, enter host name or IP address of your PostgreSQL server.
  5. In the Port field, enter the port number to connect to PostgreSQL. The default port is 5432.
  6. In the User field, enter your PostgreSQL user name.
  7. In the Password field, enter the PostgreSQL password specified for you.
  8. Click the Test connection to verify that all fields are filled correctly.
  9. When all these steps finished, click OK.

The user configuring PostgreSQL plug-in must have sufficient privileges to perform these actions:

  • To create backups, the PostgreSQL user must have the privileges to run the SELECT statements for each database and table that you want to back up.
  • To restore data, the PostgreSQL user must have full privileges to drop databases and tables and restore them from zero.

User Manual contents

Who uses our backup software?