From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
---|---|
To: | Sally <sally(dot)nayer(at)tedata(dot)net> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6266: Create temp tables on Slave |
Date: | 2011-10-25 03:51:18 |
Message-ID: | CAJKUy5i=UhfZ0VW3jXiPCgz53bfcko51cihWZoCw+nB+VW6n9g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Mon, Oct 24, 2011 at 8:48 AM, Sally <sally(dot)nayer(at)tedata(dot)net> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6266
> Logged by: Sally
> Email address: sally(dot)nayer(at)tedata(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | rihad | 2011-10-25 06:38:04 | Re: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin |
Previous Message | Craig Ringer | 2011-10-25 02:33:52 | Re: BUG #6265: Installation failure at the very beginning |