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:
Configuration dialog for the PostgreSQL plug-in.
To specify the configuration for the PostgreSQL plug-in, please follow these steps:
- Click on the New configuration option during creation of a backup or a restore task. The Settings dialog opens.
- 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.
- 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