Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 3F9AAB5DBF2 for ; Fri, 24 Jun 2011 18:21:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 91937-08 for ; Fri, 24 Jun 2011 21:21:38 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm8.bullet.mail.bf1.yahoo.com (nm8.bullet.mail.bf1.yahoo.com [98.139.212.167]) by mail.postgresql.org (Postfix) with SMTP id E08D8B5DBC8 for ; Fri, 24 Jun 2011 18:21:37 -0300 (ADT) Received: from [98.139.212.152] by nm8.bullet.mail.bf1.yahoo.com with NNFMP; 24 Jun 2011 21:21:37 -0000 Received: from [98.139.212.251] by tm9.bullet.mail.bf1.yahoo.com with NNFMP; 24 Jun 2011 21:21:37 -0000 Received: from [127.0.0.1] by omp1060.mail.bf1.yahoo.com with NNFMP; 24 Jun 2011 21:21:37 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 398015.56724.bm@omp1060.mail.bf1.yahoo.com Received: (qmail 62344 invoked by uid 60001); 24 Jun 2011 21:21:36 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1308950496; bh=5o2sGtP2wg/f0XQtPsn+6tsbap8D/lAZAmJc2JXC39o=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=JVdjuR3pm9gAJDgJv9Z3YZOo/gynpPZ4Ssvxf71xCt//w3GPwxK6BeJgJsGh8fy+XyUTNRwa12m3v4QgYMDtTYEt8523xV4m5LBwLe0bK4Xeqrym8IsjD4f6thMbP7aUWzl2UwCrY7Ay73bmq+g9uZ/3sQ8TSSJ3vdQqtEBdQYM= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=OHz6GEqhFkTtCUB85/ebq0j2lBchAjJxLQcDr3Rn5+ySF3uh586qHY9HqfFPJieg2WnSf8+oOb5EflkPGxLPKnRIV3OKQqGxk4FB4LLDOFlAvrPPsDWBlveX/0OCJQ8FiDDFmFXjamM69TKc22gLVTNWBtI47U1SFgIrMxmdD5o=; Message-ID: <877182.59904.qm@web39704.mail.mud.yahoo.com> X-YMail-OSG: nDoiDSgVM1mfGsWz.F.VrAl3nRxjCmb6G7jIiAEacaS1xfZ HPit4m0zII.hyZyyFH_ZV_hv7ZH8FrkpKCsiKX1DEALEn5AICbjpCFlmsb4l zwjyHxPFlVyIurhEex7aLwhHx_shTbzPPXKtzrPSK2SFnonk7CDyz1byNdve 1QLltt9aW6jgi8wL4hASXAfqA4B3PB8EUHKt9CJrXb6_JSzb9bagf6voKkBa UGTY4Y9p8n.YtX2chxLgbpXsPbVX_PBQeqbST9zy2.BCGffD5JvFAZDZbnyD 3kFKETj3m6BMh0fIA0bwvml8VuK2bvXFiLr1O3kQLpSM.blShBNTwNr_5PHR eC5UdHrUVzdeZo8cd7DSYA3lsRvLM8vw8cLrGphgERHuEtvW01QwyJzo- Received: from [64.126.29.122] by web39704.mail.mud.yahoo.com via HTTP; Fri, 24 Jun 2011 14:21:36 PDT X-Mailer: YahooMailWebService/0.8.111.304355 Date: Fri, 24 Jun 2011 14:21:36 -0700 (PDT) From: Bob Lunney Reply-To: Bob Lunney Subject: Parallel pg_dump on a single database To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.908 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201106/140 X-Sequence-Number: 37766 Is it possible (or smart!) to run multiple pg_dumps simulataneously on a si= ngle database, dumping different parts of the database to different files b= y using table and schema exclusion? =A0I'm attempting this and sometimes it= works and sometimes when I check the dump files with=A0=0A=0A=0A=A0 pg_res= tore -Fc > /dev/null=0A=0AI get=A0=0A=0A=A0=A0pg_restore: [custo= m archiver] found unexpected block ID (4) when reading data -- expected 423= 8=0A=0AI suspect that locks are colliding sometimes and not others, but I'm= not sure. =A0Little help? =A0=0A=0AThanks in advance,=0A=0ABob Lunney