Re: BUG #6266: Create temp tables on Slave

From: bricklen <bricklen(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
Subject: Re: BUG #6266: Create temp tables on Slave
Date: 2011-10-25 15:07:01
Message-ID: CAGrpgQ_-i8-YD=bcGDd8Z3d97pYm86JWDZzbw_V=4gfJHZgECw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-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
>

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Johnson 2011-10-25 15:12:23 Re: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin
Previous Message Christopher Browne 2011-10-25 14:47:18 Re: BUG #6266: Create temp tables on Slave