Error "Internal RELEASE failed" Creating Extract from PostgreSQL Database
Published: 10 Dec 2014 Last Modified Date: 03 May 2016
When creating an extract of a PostgreSQL database, the following error might occur:
Internal RELEASE failed Unexpected Error
Set the Hot Standby parameter on the Postgres Server to False to allow temporary tables to be created.
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.
Thank you for providing your feedback on the effectiveness of the article.