KNOWLEDGE BASE

Error "Internal RELEASE failed" Creating Extract from PostgreSQL Database


Published: 10 Dec 2014
Last Modified Date: 03 May 2016

Issue

When creating an extract of a PostgreSQL database, the following error might occur:

Internal RELEASE failed
Unexpected Error

Environment

  • Tableau Desktop
  • Postgres

Resolution

Set the Hot Standby parameter on the Postgres Server to False to allow temporary tables to be created.

 

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.
Did this article resolve the issue?