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