Re: BUG #6266: Create temp tables on Slave

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:
http://www.postgresql.org/docs/9.1/static/hot-standby.html#HOT-STANDBY-USERS

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

not with streaming replication

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación