Re: BUG #6266: Create temp tables on Slave

Dear Jaime,

Is there commercial solution that uses the same concept of wal streaming an=
d allows the Creation of temp tables on slave

I really appreciate your help

Thanks and Regards,

Sally Nayer=09
IT Systems Senior Engineer
TE Data
TE Data, Building A11- B90, Smart Village=20
Cairo- Alex Desert Road, 28 Km
6th of October 12577, Egypt
T:=A0 2 02 33 32 0733 |
F: 2 -02 33 32 0815| E: 2543
Visit: www.tedata.net
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=20


-----Original Message-----
From: jcasanov@systemguards.com.ec [mailto:jcasanov@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.nayer@tedata.net> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A06266
> Logged by: =A0 =A0 =A0 =A0 =A0Sally
> Email address: =A0 =A0 =A0sally.nayer@tedata.net
> PostgreSQL version: 9.1
> Operating system: =A0 Centos 5.5
> Description: =A0 =A0 =A0 =A0Create temp tables on Slave
> Details:
>
> We are Using replica (wal streaming replica)to replicate between Master a=
nd
> 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

--=20
Jaime Casanova=A0 =A0 =A0 =A0=A0 www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n