Re: BUG #6266: Create temp tables on Slave

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: BUG #6266: Create temp tables on Slave
Дата
Msg-id 4EA67CE0.4010307@hogranch.com
обсуждение исходный текст
Ответ на Re: BUG #6266: Create temp tables on Slave  (Sally Nayer <sally.nayer@tedata.net>)
Ответы Re: BUG #6266: Create temp tables on Slave  (Christopher Browne <cbbrowne@gmail.com>)
Список pgsql-bugs
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

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

Предыдущее
От: "Roman Lytovchenko"
Дата:
Сообщение: BUG #6268: multiple update with on cascade
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: BUG #6264: Superuser does not have inherent Replication permission