Skip to main content

Run a Backup Job


Similar to the process to create a PostgreSQL Server Database Backup Set, there are great differences between the proccesses on Microsoft and Linux Operating Systems.

To view the steps on how to run a PostgreSQL Database Backup Set for these systems, please select from below:


Run a Backup Job for PostgreSQL Server on Windows

  1. Click the Backup icon on the main interface of AhsayOBM.

    success

  2. Select the PostgreSQL database backup set which you would like to start a manual backup.

    success

  3. You can modify the “Destinations” and “Migrate Data” options.

    success

    The Migrate Data option will only be displayed if Deduplication is enabled for the backup set. When the Migrate Data option is enabled, the existing data will be migrated to the latest version during a backup job. Backup job(s) for backup sets with Migrate Data enabled may take longer to finish. For more information about this feature, refer to AhsayCBS v9 New Features Datasheet.

  4. Click on Backup to start the backup job. Once finished, “Backup Completed Successfully” will be displayed.

    success

    To check the log of your backup, click the "Magnify" icon. It will show you the log of your backup with corresponding date and time.

    success


Run Backup Job for PostgreSQL Server for Linux

Use the RunBackupSet.sh script to start a backup job manually.


#cd /usr/local/obm/bin
#sh RunBackupSet.sh "PostgreSQL Backup Linux"
-
Using APP_HOME : /usr/local/obm
Using SETTING_HOME :
Using JAVA_HOME : /usr/local/obm/jvm
Using JAVA_EXE : /usr/local/obm/jvm/bin/java
Using JAVA_OPTS : -Xrs -Xms128m -Xmx2048m -XX:MaxDirectMemorySize=512m -client -
Dsun.nio.PageAlignDirectMemory=true
Using JNI_PATH : -Djava.library.path=.:./LinX64
Using CLASSPATH : .:./cb.jar
-
Running Backup Set - 'PostgreSQL Backup Linux' ...
[2024/11/06 01:54:45] [info] [-] Start [ AhsayOBM v9.12.2.0 ]
[2024/11/06 01:54:45] [info] [-] Saving encrypted backup set encryption keys to
server...
[2024/11/06 01:54:46] [info] [1730855085673] Start Backup ... Database
[Deduplication: enabled, Deduplication scope: All files within the same backup set,
Migrate Data: disabled, Chunking: CDC(128 K-512 K)]
[2024/11/06 01:54:46] [info] [1730855085673] Using Temporary Directory
/temp/1730854397792/OBS@1730855085673
[2024/11/06 01:54:48] [info] [1730855085673] PostgreSQL version: PostgreSQL 14.13
(Ubuntu 14.13-0ubuntu0.22.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit; PgDump version: pg_dump (PostgreSQL) 14.13
(Ubuntu 14.13-0ubuntu0.22.04.1)
[2024/11/06 01:54:48] [info] [1730855085673] Index file does not exist in the
destination backup job folder "null"
[2024/11/06 01:54:48] [info] [1730855085673] Create new index
"/temp/1730854397792/OBS@1730855085673/index/index.db" since no valid index exist on
both local and destination (SQLiteTempStoreDir: /root/.obm/temp)
[2024/11/06 01:54:48] [info] [-] Start running pre-commands
[2024/11/06 01:54:48] [info] [-] Finished running pre-commands
[2024/11/06 01:54:48] [info] [1730855085673] Downloading server file list...
[2024/11/06 01:54:48] [info] [1730855085673] Index file does not exist in the
destination backup job folder "null"
[2024/11/06 01:54:48] [info] [1730855085673] Create new index
"/temp/1730854397792/OBS@1730855085673/index/index.db" since no valid index exist on
both local and destination (SQLiteTempStoreDir: /root/.obm/temp)
[2024/11/06 01:54:48] [info] [1730855085673] Downloading server file list...
Completed
[2024/11/06 01:54:49] [info] [1730855085673] Reading backup source from hard disk...
[2024/11/06 01:54:49] [info] [1730855085673] Reading backup source from hard disk...
Completed
[2024/11/06 01:54:50] [info] [1730855085673] [New Directory]... PostgreSQL
[2024/11/06 01:54:50] [info] [1730855085673] [New File]... 100% of
"PostgreSQL/pgtest00.sql"
[2024/11/06 01:54:50] [info] [1730855085673] Deduplication Info:
File="PostgreSQL/pgtest00.sql", 0.0% of file size saved by deduplication, number of
deduplicated blocks=1, total number of blocks=1, deduplicated size=555, total
size=555
[2024/11/06 01:54:50] [info] [1730855085673] Start validating the presence and size
of backup data in destination "AhsayCBS"...
[2024/11/06 01:54:50] [info] [1730855085673] File: "1730854397792/blocks/2024-11-06-
01-54-35/0/000000.bak", Size: 1,680, OK
[2024/11/06 01:54:50] [info] [1730855085673] Finished validating the presence and
size of backup data in destination "AhsayCBS"
[2024/11/06 01:54:50] [info] [1730855085673] Start running retention policy on backup
set "PostgreSQL Backup Linux(1730854397792)", "AhsayCBS(1730855085673)"
[2024/11/06 01:54:50] [info] [1730855085673] Start processing space freeing up on
backup set= "PostgreSQL Backup Linux (1730854397792)" destination= "AhsayCBS
(1730855085673)"
[2024/11/06 01:54:51] [info] [1730855085673] Space freeing up on backup set=
"PostgreSQL Backup Linux (1730854397792)" destination= "AhsayCBS (1730855085673)" is
completed
[2024/11/06 01:54:51] [info] [1730855085673] Finished running retention policy on
backup set "PostgreSQL Backup Linux(1730854397792)", "AhsayCBS(1730855085673)"
[2024/11/06 01:54:51] [info] [1730855085673] Deleting out of retention period
recycled files, Recycle Bin:enabled, Empty all files in recycle bin:disabled...
[2024/11/06 01:54:51] [info] [1730855085673] Delete out of retention period recycled
files result - Size: 0 B, File Count: 0
[2024/11/06 01:54:51] [info] [1730855085673] Deleting out of retention period
recycled files, Recycle Bin:enabled, Empty all files in recycle bin:disabled...
Completed
[2024/11/06 01:54:52] [info] [-] Saving server information to destination.
[2024/11/06 01:54:52] [info] [1730855085673] Saving encrypted backup file index to
1730854397792/blocks/2024-11-06-01-54-35 at destination AhsayCBS...
[2024/11/06 01:54:52] [info] [1730855085673] Saving decrypted backup file index to
AhsayCBS at destination /temp/1730854397792/OBS@1730855085673/index…
[2024/11/06 01:54:53] [info] [1730855085673] Saving encrypted backup file index to
1730854397792/blocks/2024-11-06-01-54-35 at destination AhsayCBS...
[2024/11/06 01:54:53] [info] [-] Start running post-commands
[2024/11/06 01:54:53] [info] [-] Finished running post-commands
[2024/11/06 01:54:56] [info] [1730855085673] Deleting temporary file
/temp/1730854397792/OBS@1730855085673
[2024/11/06 01:54:56] [info] [-] Deleting temporary file
/temp/1730854397792/SpoolArea/1730855085673
[2024/11/06 01:54:57] [info] [1730855085673] Total New Files = 1
[2024/11/06 01:54:57] [info] [1730855085673] Total New Directories = 1
[2024/11/06 01:54:57] [info] [1730855085673] Total New Links = 0
[2024/11/06 01:54:57] [info] [1730855085673] Total Updated Files = 0
[2024/11/06 01:54:57] [info] [1730855085673] Total Deleted Files = 0
[2024/11/06 01:54:57] [info] [1730855085673] Total Deleted Directories = 0
[2024/11/06 01:54:57] [info] [1730855085673] Total Deleted Links = 0
[2024/11/06 01:54:57] [info] [1730855085673] Total Moved Files = 0
[2024/11/06 01:54:57] [info] [1730855085673] Total Dedupe Saving for this job = 0 B
[2024/11/06 01:54:57] [info] [1730855085673] Total Backup Data Size for this job =
555 B
[2024/11/06 01:54:57] [info] [1730855085673] Total Dedupe Saving for destination = 0
B
[2024/11/06 01:54:57] [info] [1730855085673] Total Backup Data Size for destination =
555 B
[2024/11/06 01:54:57] [info] [1730855085673] Total recycled file size = 0
[2024/11/06 01:54:57] [info] [1730855085673] Total recycled files = 0
[2024/11/06 01:54:57] [info] [1730855085673] Backup Completed Successfully