Embedded Files
PostgreSQL 9.3
PostgreSQL 9.3
Backing up the PostgreSQL database is performed by either using the pgAdmin tool or the command line tool pg_dump.exe.
A detailed explanation of the procedure using the pgAdmin tool follows as well as a short example of pg_dump.exe usage. The following steps illustrate the step-by-step process of performing a backup of a PostgreSQL database schema cm_01.
Note
- There is a significant performance increase in running pgAdmin from the same computer that the PostgreSQL database server is running on.
- If your Content Manager version is old such as 6, 10.2, 10.5, please check the number of network errors.
- Stop Apache Tomcat service and Scala Transmission Server Service.
- Right Click on TaskBar>Task Manager>Open Services>Stop Apache Tomcat Services and Scala Transmission Server Service
- Open the pgAdmin tool by navigating to Start -> Programs -> PostgreSQL -> pgAdmin.
- Connect to your database server using the same Username and Password you entered when you installed Content Manager. Select the database schema you want to backup, then right-click and select Backup.
- Set the Format to tar in the backup dialog, choose a path and filename for the backup file, and press OK to start the backup.
- Filename example YYYYMMDD_CMVerion100502 Do not use period (.)
- Verify the result. Wait for the backup process to finish, and verify that the final message is “Process returned exit code 0”. If the exit code is different, this means that the backup was not successful. Please try it again.
- Check the size of the backup file.
- If it is more than 50MB or the returned exit code 1, please check the number of network errors and delete errors.
- If the returned exit code 1, Foreign Keys might be missing.
6. Start the Apache Tomcat Services and Scala Transmission Server Service.
2 Using Command Line
- Using the command line, you may choose to use the command line tool pg_dump.exe to backup the database. To create the same backup as shown above, execute the following command:
pg_dump --format=custom --compress=5 -U postgres -W cm_01 > C:\tmp\backup\db.backup
- Please refer to the PostgreSQL manual for more details when using the command line tools
Report abuse