Backing up and restoring a database on PostgreSQL

Backing up using the pg_dump command

1. Open a command prompt window.
2. Execute the following command to backup your PostgreSQL database into a file:

   pg_dump -b -f <backup_directory_path>\<backup_file_name> -F t -d "<db_name>" -h <postgre_host> -w -p <postgre_port> -U <postgre_username>

Restoring using the pg_restore command

1. Open a command prompt window.
2. Execute the following command to restore the file into the database server:

   pg_restore -c -F t -d "<db_name>" -h <postgre_host> -w -p <postgre_port> -U <postgre_username> --if-exists <backup_directory_path>\<backup_file_name>

   All the database objects and data are dropped before recreating them.

3. Restart Talend Data Catalog application server.
4. To ensure the optimal Talend Data Catalog application server performance, go to MANAGE > Schedules to run the database maintenance script.
5. Right-click Run Database Maintenance and click Run operation now to update the database indexes and statistics.

For more information on the pg_dump and pg_restore commands, refer to the PostgreSQL documentation.