Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master
Дата
Msg-id 3076.1357768309@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master  (James Cowell <jcowell@btinternet.com>)
Ответы Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-general
James Cowell <jcowell@btinternet.com> writes:
> But pg_bulkload only puts the index updates into WAL if you also have
>
> archive_mode = on
>
> I guess it needs to test wal_level rather than archive mode now?  It looks like changes to the project have been
minimalfor some time, which is a shame because it's a very useful tool. 

Oh, the code in question is in pg_bulkload not the backend?  Yeah, it
sounds like it hasn't tracked some core-code changes.  In particular
you might point the author at
http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=40f908bdcdc726fc11912cd95dfd2f89603d1f37#patch10
which shows how it needs to be done in 9.0 and later.

            regards, tom lane


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

Предыдущее
От: Ben Chobot
Дата:
Сообщение: Re: How to store clickmap points?
Следующее
От: felix@crowfix.com
Дата:
Сообщение: How can I detect if a schema exists?