Skip site navigation (1) Skip section navigation (2)

Re: BUG #6266: Create temp tables on Slave

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: Sally <sally(dot)nayer(at)tedata(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6266: Create temp tables on Slave
Date: 2011-10-25 03:51:18
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
On Mon, Oct 24, 2011 at 8:48 AM, Sally <sally(dot)nayer(at)tedata(dot)net> wrote:
> The following bug has been logged online:
> Bug reference:      6266
> Logged by:          Sally
> Email address:      sally(dot)nayer(at)tedata(dot)net
> PostgreSQL version: 9.1
> Operating system:   Centos 5.5
> Description:        Create temp tables on Slave
> Details:
> We are Using replica (wal streaming replica)to replicate between Master and
> slave.
> We need to be able to create temp tables on Slave,

you can't. this isn't a bug but a known limitation and is documented here:

> Is there any workaround?
> How could we create temp database and tables on slave?

not with streaming replication

Jaime Casanova
Professional PostgreSQL: Soporte 24x7 y capacitación

In response to


pgsql-bugs by date

Next:From: rihadDate: 2011-10-25 06:38:04
Subject: Re: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin
Previous:From: Craig RingerDate: 2011-10-25 02:33:52
Subject: Re: BUG #6265: Installation failure at the very beginning

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group