Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: Corrupt indexes on slave when using pg_bulkload on master
Date
Msg-id CAMkU=1yS+v_PJbSKY6oHhg+QxYPTp7am1Y2aEoZnBOS5jtz8gw@mail.gmail.com
Whole thread Raw
In response to Corrupt indexes on slave when using pg_bulkload on master  (James Cowell <jcowell@btinternet.com>)
Responses Re: Corrupt indexes on slave when using pg_bulkload on master  ("James Cowell" <jcowell@btinternet.com>)
List pgsql-general
Tree view 
On Wed, Dec 5, 2012 at 5:17 AM, James Cowell <jcowell@btinternet.com> wrote:
> I'm using pg_bulkload to load large amounts of CSV data into a postgres
> database hourly.
>
> This database is replicated to a second node.

pg_bulkload is fundamentally incompatible with PITR, streaming, and
forms of replication that depend on those things.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Extending the KD Tree index in Postgresql 9.2.1
Next
From: icholy
Date:
Subject: libpq - prevent automatic reconnect