Maintenance Configuration Parameters
This section describes the configuration settings that allow you to back up and restore your back end SQL component.
For example:
[Backup] PgDumpPath=c:\Users\<username>\AppData\Roaming\postgresql\bin\pg_dump.exe PgRestorePath=c:\Users\<username>\AppData\Roaming\postgresql\bin\pg_restore.exe BackupSQLDatabase=True
NOTE: To back up and restore the SQL files, the client machine on which Coordinator is running must have PostgreSQL 9.0 or higher installed. In addition, you must specify the password to use to connect to the SQL backend database in either the ~/.pgpass
file (UNIX), or the pgpass.conf
file (Windows).