Postgres Pro
Downloads
Home   >   mailing lists

Re: Streaming replication and slave-local temp tables - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Streaming replication and slave-local temp tables
Date
Msg-id CAFj8pRCCXBdgzesvLEzoL5V=jT8X2VcXSOL9fjJkPkG85ZpgGA@mail.gmail.com
Whole thread Raw
In response to Streaming replication and slave-local temp tables  (Ivan Voras <ivoras@gmail.com>)
List pgsql-general
Tree view
Hi

2016-03-09 18:14 GMT+01:00 Ivan Voras <ivoras@gmail.com>:
Hello,

Is it possible (or will it be possible) to issue CREATE TEMP TABLE statements on the read-only slave nodes in master-slave streaming replication in recent version of PostgreSQL (9.4+)?

Currently it is not possible. There are two plans related to this issue: 1. global temp tables, 2. logical replication. The work on logical replication is near finalization and probably it will be available in 9.6.

Regards

Pavel 

pgsql-general by date:

Previous
From: Ivan Voras
Date:
Subject: Streaming replication and slave-local temp tables
Next
From: Adam Brusselback
Date:
Subject: Re: Plan to support predicate push-down into subqueries with aggregates?