Merging two database dumps

From: "Alex O'Ree" <spyhunter99(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Merging two database dumps
Date: 2018-06-13 11:17:00
Message-ID: CALLT8kjR2P0Pj0LMnBk1WrBO1jsvidBWacSpiEikUdEGsXJFWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a situation with multiple postgres servers running all with the same
databases and table structure. I need to periodically export the data from
each of there then merge them all into a single server. On occasion, it's
feasible for the same record (primary key) to be stored in two or more
servers

I was using pgdump without the --insert option however I just noticed that
pgrestore will stop inserting into a table when the conflict occurs,
leaving me with an incomplete set.

Question is what are my other options to skip over the conflicting record
when merging?

From the docs, it appears that making dumps with the --insert option may be
the only way to go however performance is an issue. In this case would
dropping all indexes help?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavan Teja 2018-06-13 11:23:52 Re: Merging two database dumps
Previous Message Vadim Nevorotin 2018-06-13 10:44:54 Re: First query on each connection is too slow