Skip site navigation (1) Skip section navigation (2)

Re: BUG #6266: Create temp tables on Slave

From: Sally Nayer <sally(dot)nayer(at)tedata(dot)net>
To: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6266: Create temp tables on Slave
Date: 2011-10-25 07:11:23
Message-ID: 67F68314DB8AF24FA3B717A56B5D927012A90E@EXCH-MBX-01.TE-Data.core (view raw or flat)
Thread:
Lists: pgsql-bugs
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: jcasanov(at)systemguards(dot)com(dot)ec [mailto:jcasanov(at)systemguards(dot)com(dot)ec] On Behalf Of Jaime Casanova
Sent: Tuesday, October 25, 2011 5:51 AM
To: Sally Nayer
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #6266: Create temp tables on Slave


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

In response to

Responses

pgsql-bugs by date

Next:From: Maksym BogukDate: 2011-10-25 08:58:45
Subject: BUG #6267: Wrong results in pg_database_size
Previous:From: rihadDate: 2011-10-25 06:38:04
Subject: Re: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group