Making a backup of Avaya Contact Analyzer
You know, before you update every row in the callsegmentfact table$ /opt/PostgreSQL/9.5/bin/pg_dump -U postgres --format=c \
--file=ahadatamart_pg9.5_2018-01-12.sqlc ahadatamart
Optional: You can also add --table=callsegmentfact
before ahadatamart
if you only want to back up the callsegmentfact
table.
Warning: This takes a while. Mine took around an hour to complete.