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

From: James Cowell <jcowell(at)btinternet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master
Date: 2013-01-09 10:43:27
Message-ID: 1357728207.5878.YahooMailNeo@web186004.mail.ir2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Tom,
 
I had replication enabled and it was working fine but I hadn't turned archive mode on yet (it was on the todo list but needed a log location).
 
I had WAL settings:
 
wal_level = hot_standby
max_wal_senders = 5
wal_keep_segments = 32
wal_buffers = 32MB
 
And checkpoint settings:
 
checkpoint_segments = 64
checkpoint_completion_target = 0.7
 
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 minimal for some time, which is a shame because it's a very useful tool. 
 
Cheers,
 
James
 
 

________________________________
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James Cowell <jcowell(at)btinternet(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>; Jeff Janes <jeff(dot)janes(at)gmail(dot)com>; "wd(at)wdicc(dot)com" <wd(at)wdicc(dot)com>
Sent: Tuesday, 8 January 2013, 18:02
Subject: Re: [GENERAL] [Solved] Corrupt indexes on slave when using pg_bulkload on master

James Cowell <jcowell(at)btinternet(dot)com> writes:
> I enabled archive mode (which I didn't care about before as the database only holds 36 hours of data) and the indexes seem to replicate over fine.  I suppose the problem here is lack of documentation, but at least the code is well commented :)

> It looks like pg_bulkload works just fine with replication so long as it's set up right.

Hm.  I had thought we had interlocks in there to prevent turning on
replication unless the WAL level was sufficiently high.  It sounds like
you managed to dodge that sanity check.  Could you be more specific about
what your replication configuration looks like?

            regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message aasat 2013-01-09 13:55:14 Bug: dblink_send_query not work on 9.2?
Previous Message Fredrik.HuitfeldtMadsen 2013-01-09 10:14:38 Database connections seemingly hanging