PostgreSQL is a secondary database used by many of our newer products, including Job Management.
The default method of backing up the postgresql database is by dumping the entire database to an archive file that is captured as part of the regular Eclipse database backup. On Linux, the backup script is located at /u2/pgsql/pgsql_backup by default. On AIX, the backup script is located at /u2/pgsql/bin/backup.sh by default.
This backup script is scheduled to run daily via crontab. On Linux, this is accomplished via a symlink in /etc/cron.daily:
ln -s /u2/pgsql/pgsql_backup /etc/cron.daily/pgsql_backup
On AIX, this is accomplished via a crontab entry similar to the following:
0 0 * * * /u2/pgsql/bin/backup.sh >/dev/null 2>&1