> 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 Ca
Well, it is imaginable for there to be some side mechanism to enable use of
temporary tables on a WAL-based replica, after all, we have leapt through
enough hoops to get read transactions working.
That being said...
A) a solution for how to do this has not yet emerged, so it seems not too
likely
On 10/25/11 12:11 AM, Sally Nayer wrote:
Is there commercial solution that uses the same concept of wal streaming and
allows the Creation of temp tables on slave
WAL files represent 'delta changes' between the state of the postgres
file system. *anything* that changes database files on the s
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 wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6266
> Logged by:
On Mon, Oct 24, 2011 at 8:48 AM, Sally wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6266
> Logged by: Sally
> Email address: sally.na...@tedata.net
> PostgreSQL version: 9.1
> Operating system: Centos 5.5
> Description: Create temp tables on S
The following bug has been logged online:
Bug reference: 6266
Logged by: Sally
Email address: sally.na...@tedata.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
