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:

Making a new PostgreSQL plug-in configuration
  1. Click on the New configuration option during creation of a backup or a restore task. The Settings dialog opens.
  2. In the Configuration field, enter a name for the configuration created.
    • In the Host field, enter host name or IP address of your PostgreSQL server.
    • In the Port field, enter the port number to connect to PostgreSQL. The default port is 5432.
    • In the User field, enter your PostgreSQL user name.
    • In the Password field, enter the PostgreSQL password specified for you.
    • Click the Test connection to verify that all fields are filled correctly.
  3. To set up a secure connection, select the SSL tab.
    • Here, you can choose the preferred SSL connection mode, specify the path to the root certificate, and provide the path to the client certificate and its key.
    Configuring SSL mode

    Configuring SSL mode

  4. When all these steps finished, click OK.

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

Note: For PostgreSQL version 10 and later versions, you need to use Handy Backup with 64 bits capacity. The choice of the bit depth is carried out at the stage of the program installation. Instructions for choosing the bit depth.

User Manual contents

Who uses Handy Backup?