Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 1B6AD1337B84 for ; Mon, 13 Dec 2010 16:42:20 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 98470-01 for ; Mon, 13 Dec 2010 20:42:13 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web114714.mail.gq1.yahoo.com (web114714.mail.gq1.yahoo.com [98.136.183.141]) by mail.postgresql.org (Postfix) with SMTP id 443801336971 for ; Mon, 13 Dec 2010 16:42:11 -0400 (AST) Received: (qmail 3178 invoked by uid 60001); 13 Dec 2010 20:42:10 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.br; s=s1024; t=1292272930; bh=KIAFFM2ZpWODjiP28+sk7ZD7RdQ48h2wvFAGQ6h+2Zs=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=voLwau0Dra7qJqrt7bEr2eb9BTmxg7FQH6LVxHO/jZ7nrE+ZPTprw5rxH70Bzcs5CCyweDyN4xZc8ExDDlu/VJqsj/Q2JVCrfFXcHsBEqbdB4Usb1hoTJBru81T3qry9jXXhLCxVS2WeNemgQg65IhpjHmQ4RKy5z0Qhj01XHqE= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=zZXiOPxanBkOthmSlDcJnLC0Z7Ts/wMKq+iVuldNQl4+z2i0sMgAfidJHrArAz/K2SbxDvn1TYOuMnZTIODLjeDMBYMN5pk4rDxqZarJp7D9p0hSvT1O766nPD7yDJj4YsydF138NTS3Yq4LEBWxVJbbI/liXfHhToEQreFns5w=; Message-ID: <336291.2324.qm@web114714.mail.gq1.yahoo.com> X-YMail-OSG: 4hHKTzEVM1nq7YyqgpyUrggzlzNIXnT4B201xfEim4snBET IEiYl5fXLGv6kZHvgiipFIK7uhNrIdidNB3qFv.1Dx6nFATzrmw_yV.GERG_ RcX03vH80pPomXND.7kxkvk1.puImEGNNn9PrWjW72I.5HwpEIaKg_B1ryrl kP0XxTIFl9.VvABkkgS1gMDVVpK_IbAheBQVSwWO_7QO3ZqZb383MUV0TuiF fJiphSiIhKpB8FWkYwYl1Lu6ZO50QhhpS.4FwgyO37RSHs7P3FL_siT0awuy zim18UOxnNTmBsxzefd.dMs7GT0YnEVUqaG13Aok7cB1fLezcJQlfgUUWNFo Bp0Hv1vzhqBbJMoWL8NPoAW1jaXzTh2EMxV2u.Jz7 Received: from [187.78.191.162] by web114714.mail.gq1.yahoo.com via HTTP; Mon, 13 Dec 2010 12:42:09 PST X-Mailer: YahooMailRC/553 YahooMailWebService/0.8.107.285259 Date: Mon, 13 Dec 2010 12:42:09 -0800 (PST) From: paulo matadr Subject: 8.4 restore parallel To: admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-987681822-1292272929=:2324" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_20=-0.001, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201012/101 X-Sequence-Number: 36330 --0-987681822-1292272929=:2324 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi all,=0AI made an backup of database 8.3 =0Atest.dmp=0Aand tested restore= in (8.4.5) using parallel=0Apg_restore -d xxx -n yyy -t kkkk -j 3 < = test.dmp=0A=0AAnd give error:=0Apg_restore: [custom archiver] cannot reopen= stdin=0Apg_restore: [archiver] worker process failed: exit code 1=0A=0A=0A= Why not working?=0A=0ARegards=0A=0A=0A Paulo=0A=0A=0A=0A --0-987681822-1292272929=:2324 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi all,
I made an backup of database 8.3 test.dmp
and tested restore in (8.4.5) using parallel
pg_restore&nbs= p; -d xxx -n yyy -t kkkk     -j 3  < test.dmp
And give error:
pg_restore: [custom archiver] cannot reopen stdin
pg= _restore: [archiver] worker process failed: exit code 1


Why not = working?

Regards

 
Paulo

=0A
=0A=0A=0A=0A   --0-987681822-1292272929=:2324--