...
If the PostgreSQL database server is used for purpose of archiving, we recommend using PostgreSQL version 9.5 or higher. These versions support the UPSERT command and allow you to set the Upsert archive Upsert archive parameter to 1.
PostgreSQL settings
...
We recommend setting the archive parameter Upsert to Upsert to value 1. This setting activates using of UPSERT command, which was implemented in PostgreSQL 9.5. This setting requires correct setting of ODBC parameters described in the following paragraph.
...