Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master - Mailing list pgsql-general

From Tom Lane
Subject Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master
Date
Msg-id 3076.1357768309@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master  (James Cowell <jcowell@btinternet.com>)
Responses Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master  (Fujii Masao <masao.fujii@gmail.com>)
List 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 by date:

Previous
From: Ben Chobot
Date:
Subject: Re: How to store clickmap points?
Next
From: felix@crowfix.com
Date:
Subject: How can I detect if a schema exists?