5 Replies Latest reply on Jan 26, 2015 12:55 PM by Russell Christopher

    postgres hot_standby (read-only replica)

    Brad Langhorst

      I'd like to connect to a hot standy of my postgres database to unload the master a bit.

       

      Unfortunately, tableau is using some fancy temp table stuff that you can't do on a read-only database.

       

      2013-07-02 19:09:34 EDT LOG:  streaming replication successfully connected to primary

      2013-07-02 19:09:34 EDT LOG:  incomplete startup packet

      2013-07-02 19:10:22 EDT ERROR:  cannot execute SELECT INTO in a read-only transaction

      2013-07-02 19:10:22 EDT STATEMENT:  -- statement does not return rows

        SELECT *

        INTO TEMPORARY TABLE "#Tableau_1_Connect"

        FROM (SELECT 1 AS COL) AS CHECKTEMP

        LIMIT 1

      2013-07-02 19:10:22 EDT ERROR:  cannot execute DROP TABLE in a read-only transaction

      2013-07-02 19:10:22 EDT STATEMENT:  DROP TABLE "#Tableau_1_Connect"

      2013-07-02 19:10:22 EDT ERROR:  cannot execute CREATE TABLE in a read-only transaction

      2013-07-02 19:10:22 EDT STATEMENT:  CREATE LOCAL TEMPORARY TABLE "#Tableau_2_Connect" (

        "COL" INTEGER

        ) ON COMMIT PRESERVE ROWS

      2013-07-02 19:10:22 EDT ERROR:  cannot execute DROP TABLE in a read-only transaction

      2013-07-02 19:10:22 EDT STATEMENT:  DROP TABLE "#Tableau_2_Connect"

       

      Any suggestions?