Dear Jaime, Is there commercial solution that uses the same concept of wal streaming and allows the Creation of temp tables on slave
I really appreciate your help Thanks and Regards, Sally Nayer IT Systems Senior Engineer TE Data TE Data, Building A11- B90, Smart Village Cairo- Alex Desert Road, 28 Km 6th of October 12577, Egypt T: 2 02 33 32 0733 | F: 2 -02 33 32 0815| E: 2543 Visit: www.tedata.net -----Original Message----- From: jcasa...@systemguards.com.ec [mailto:jcasa...@systemguards.com.ec] On Behalf Of Jaime Casanova Sent: Tuesday, October 25, 2011 5:51 AM To: Sally Nayer Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #6266: Create temp tables on Slave 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
