Loading

Error "Internal RELEASE failed" Creating Extract from PostgreSQL Database

Дата публикации: Apr 13, 2024
Описание
When creating an extract of a PostgreSQL database, the following error might occur:

"FATAL: terminating connection due to conflict with recovery

internal RELEASE failed

Unable to create extract"

or

"Error fetching next group.;

Internal savepoint error

Unable to create extract."

Cause

Postgresql doesn't allow temp tables to be written on a database that is a hot standby since it's in read-only mode.

When the parameter 'hot_standby' is set to true on a standby server, the server will start accepting connections after the restoration has reached a consistent state. All connections that follow will be read-only connections; even temporary tables can not be used.
Решение
Work with your PostgreSQL DBA to consider the needs of your replication strategy. For example, setting the Hot Standby parameter on the Postgres Server to False will allow temporary tables to be created.

 
Номер статьи базы знаний

001474115

 
Загрузка
Salesforce Help | Article