Creation of TEMPORARY TABLE in Slave Database

Question

I have two PostgreSQL database servers. One is the master and another is a slave server which is in read only mode. I have written a few functions that CREATE TEMPORARY TABLE within the function. Now my question: is it possible to run all of those functions in slave server? If it is possible, then how?

Answer 1

See the manuals.

All such connections are strictly read-only; not even temporary tables may be written

You will want something like slony or bucardo doing trigger-based replication if you want the replica to support write operations.

---

Edit: or, nowadays you can use logical replication.