Re: BUG #6266: Create temp tables on Slave - Mailing list pgsql-bugs

From bricklen
Subject Re: BUG #6266: Create temp tables on Slave
Date
Msg-id CAGrpgQ_-i8-YD=bcGDd8Z3d97pYm86JWDZzbw_V=4gfJHZgECw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #6266: Create temp tables on Slave  (Sally Nayer <sally.nayer@tedata.net>)
List pgsql-bugs
> 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-US=
ERS
>
>> Is there any workaround?
>> How could we create temp database and tables on slave?
>>
>
> not with streaming replication
>
> --
> Jaime Casanova=C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0 www.2ndQuadrant.com
> Professional PostgreSQL: Soporte 24x7 y capacitaci=C3=B3n
>

I wonder if a workaround is possible using dblink, pl/proxy, or FDW to
write out to a different "temp" db?

pgsql-bugs by date:

Previous
From: Christopher Browne
Date:
Subject: Re: BUG #6266: Create temp tables on Slave
Next
From: snpmonster
Date:
Subject: Re: BUG #6255: Unable to Install (Binary, One Click Installer