Re: BUG #6266: Create temp tables on Slave

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: BUG #6266: Create temp tables on Slave
Дата
Msg-id CAFNqd5Um=8vudrqZXdW2TVpjnvqFMQkSJRsxfq6HwUAzaQSPaw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #6266: Create temp tables on Slave  (John R Pierce <pierce@hogranch.com>)
Список pgsql-bugs
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=E9 -
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@hogranch.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-bugs<http://www.postgresql.org=
/mailpref/pgsql-bugs>
>

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6267: Wrong results in pg_database_size
Следующее
От: bricklen
Дата:
Сообщение: Re: BUG #6266: Create temp tables on Slave