Description: Perform the below steps to take back up of Infoworks Postgres DB.
i) source /opt/infoworks/bin/env.sh
Assuming that Infoworks is installed under /opt/infoworks directory (IW_HOME)
ii) {IW_HOME}/resources/postgres/pgsql/bin/pg_dump -U infoworks-user -W -F t airflow -p 3008 -h {provide the hostname/IP address of the Edge node} > infoworks-postgres-backup.tar
IN11**rk
For example:
ii) /opt/infoworks/resources/postgres/pgsql/bin/pg_dump -U infoworks-user -W -F t airflow -p 3008 -h 10.18.1.25 > infoworks-postgres-backup.tar
Applicable Infoworks(IWX) Versions:
IWX versions: v2.x,v3.x,v4.x