Parallel pg_dump on a single database

From: Bob Lunney <bob_lunney(at)yahoo(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Parallel pg_dump on a single database
Date: 2011-06-24 21:21:36
Message-ID: 877182.59904.qm@web39704.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Is it possible (or smart!) to run multiple pg_dumps simulataneously on a single database, dumping different parts of the database to different files by using table and schema exclusion?  I'm attempting this and sometimes it works and sometimes when I check the dump files with 

  pg_restore -Fc <dumpfile> > /dev/null

I get 

  pg_restore: [custom archiver] found unexpected block ID (4) when reading data -- expected 4238

I suspect that locks are colliding sometimes and not others, but I'm not sure.  Little help?  

Thanks in advance,

Bob Lunney

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alan Gutierrez 2011-06-24 21:27:42 Fast Shutdown and Transactions
Previous Message Greg Spiegelberg 2011-06-23 21:03:04 Re: How to change all owners on all objects in a schema