Re: Streaming replication and temp table operations - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Streaming replication and temp table operations
Date
Msg-id BANLkTik9TY_XT=+jcsrXuD_fGZ7gi+nRCw@mail.gmail.com
Whole thread Raw
In response to Streaming replication and temp table operations  (Joel Stevenson <jstevenson@bepress.com>)
List pgsql-general
On Tue, Jun 21, 2011 at 2:15 PM, Joel Stevenson <jstevenson@bepress.com> wrote:
> Hi all,
>
> Does anyone know if temp tables and the operations on them (like inserting or copying to) are replicated from master
tostandby servers via the new PG WAL shipping replication?  Given that temp tables are only accessible per-session it
wouldseem unnecessary but if the shipping is happening at the WAL log level is that sort of thing considered? 

Pretty sure that with 9.0's streaming replication, the no WAL of temp
tables gets turned off.  I've certainly seen references to such float
by.  But I'd check the docs to be sure.

pgsql-general by date:

Previous
From: Joel Stevenson
Date:
Subject: Streaming replication and temp table operations
Next
From: "Kevin Grittner"
Date:
Subject: abusing session_replication_mode