On Mon, Oct 24, 2011 at 8:48 AM, Sally <sally.na...@tedata.net> wrote: > > The following bug has been logged online: > > Bug reference: 6266 > Logged by: Sally > Email address: sally.na...@tedata.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
