Parallel pg_dump on a single database - Mailing list pgsql-admin

From Bob Lunney
Subject Parallel pg_dump on a single database
Date
Msg-id 877182.59904.qm@web39704.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Parallel pg_dump on a single database  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Is it possible (or smart!) to run multiple pg_dumps simulataneously on a single database, dumping different parts of
thedatabase to different files by using table and schema exclusion?  I'm attempting this and sometimes it works and
sometimeswhen 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

pgsql-admin by date:

Previous
From: Greg Spiegelberg
Date:
Subject: Re: How to change all owners on all objects in a schema
Next
From: Alan Gutierrez
Date:
Subject: Fast Shutdown and Transactions