Re: BUG #6266: Create temp tables on Slave

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 that such a feature will enter 9.2, let alone earlier versions. It's
not yet really scheduled for 9.2, so it would be wiser to assume 9.3 or
later, ergo don't make any plans earlier than 2013...

B) yes, indeed, "logical" replication systems like Slony, Londiste, and
Bucardo are the alternative at present.

I have been hearing comments to the effect of these systems being passé -
when WAL replication does not support fairly important cases such as
allowing reports to use temporary tables, that seems rather premature.
On Oct 25, 2011 5:10 AM, "John R Pierce" <pierce(at)hogranch(dot)com> wrote:

> 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 slave side would
> render the WAL files inherently unusable.
>
> to do what you want would require using a fundamentally different
> replication method, such as Slony or Bucardo.
>
>
>
> --
> john r pierce N 37, W 122
> santa cruz ca mid-left coast
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-bugs<http://www.postgresql.org/mailpref/pgsql-bugs>
>