org.postgresql.util.PSQLException: FATAL: terminating connection due to conflict with recovery

Description:

A Data Import job from an external Postgres data store fails with the following postgres exception:

org.postgresql.util.PSQLException: FATAL: terminating connection due to conflict with recovery

Cause:
This is due to insufficient resources allocated by certain parameters in postgresql.conf

Resolution:
In this case, try increasing the values for the following parameters:

max_standby_archive_delay

max_standby_streaming_delay

These parameters can only be set in the postgresql.conf configuration file on your postgres database server. Check with your postgresql database administrator to modify this.

Other Resources:

Have more questions? Submit a request

Comments

Powered by Zendesk