Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WGBX6-00066F-Pa for pgsql-admin@arkaria.postgresql.org; Wed, 19 Feb 2014 18:06:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WGBX6-0005aR-5I for pgsql-admin@arkaria.postgresql.org; Wed, 19 Feb 2014 18:06:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WGBX4-0005Xa-KD for pgsql-admin@postgresql.org; Wed, 19 Feb 2014 18:06:06 +0000 Received: from mail-bn1lp0154.outbound.protection.outlook.com ([207.46.163.154] helo=na01-bn1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WGBWx-0004iC-NJ for pgsql-admin@postgresql.org; Wed, 19 Feb 2014 18:06:05 +0000 Received: from BLUPR05MB417.namprd05.prod.outlook.com (10.141.27.15) by BLUPR05MB420.namprd05.prod.outlook.com (10.141.27.26) with Microsoft SMTP Server (TLS) id 15.0.868.8; Wed, 19 Feb 2014 18:05:55 +0000 Received: from BLUPR05MB417.namprd05.prod.outlook.com ([169.254.11.19]) by BLUPR05MB417.namprd05.prod.outlook.com ([169.254.11.19]) with mapi id 15.00.0878.008; Wed, 19 Feb 2014 18:05:55 +0000 From: Mel Llaguno To: Magnus Hagander CC: "pgsql-admin@postgresql.org" Subject: Re: Availability of parallel jobs option in pg_dumpall Thread-Topic: [ADMIN] Availability of parallel jobs option in pg_dumpall Thread-Index: AQHPLZR15V/bDruOGEivReW0CzU3+pq83rCA//+LQIA= Date: Wed, 19 Feb 2014 18:05:54 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.3.9.131030 x-originating-ip: [66.18.194.18] x-forefront-prvs: 012792EC17 x-forefront-antispam-report: SFV:NSPM; SFS:(10009001)(377454003)(199002)(189002)(51914003)(24454002)(92726001)(36756003)(54316002)(56776001)(74706001)(81816001)(69226001)(56816005)(15975445006)(81542001)(83506001)(77982001)(66066001)(4396001)(16236675002)(74366001)(81342001)(74876001)(46102001)(54356001)(47736001)(76796001)(93516002)(59766001)(94946001)(79102001)(76482001)(90146001)(19580405001)(74502001)(47446002)(80976001)(93136001)(87266001)(80022001)(74662001)(81686001)(19580395003)(83322001)(31966008)(47976001)(65816001)(87936001)(95416001)(83072002)(76786001)(85306002)(49866001)(92566001)(86362001)(50986001)(51856001)(85852003)(77096001)(95666001)(53806001)(2656002)(15202345003)(63696002)(94316002); DIR:OUT; SFP:1101; SCL:1; SRVR:BLUPR05MB420; H:BLUPR05MB417.namprd05.prod.outlook.com; CLIP:66.18.194.18; FPR:6D8AE970.BC3006C9.78F17984.4E3FC6D.2019C; InfoNoRecordsA:1; MX:1; LANG:en; Content-Type: multipart/alternative; boundary="_000_CF2A4082116F5mllagunocoveritycom_" MIME-Version: 1.0 X-OriginatorOrg: coverity.com X-Pg-Spam-Score: 0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_CF2A4082116F5mllagunocoveritycom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Magnus, Thanks for the clarification. M. From: Magnus Hagander > Date: Wednesday, February 19, 2014 at 11:03 AM To: Mel Llaguno > Cc: "pgsql-admin@postgresql.org" > Subject: Re: [ADMIN] Availability of parallel jobs option in pg_dumpall On Wed, Feb 19, 2014 at 6:03 PM, Mel Llaguno > wrote: Does anyone know if the the -j option is available for the pg_dumpall command in PG 9.3.x? There is no reference of it in the documentation (unlike pg_dump) which implies that pg_dumpall functions differently than pg_dump. -j is only available for pg_dump, that is correct. It requires an output fo= rmat of "directory", which is not supported by pg_dumpall. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ --_000_CF2A4082116F5mllagunocoveritycom_ Content-Type: text/html; charset="us-ascii" Content-ID: <5FADAF5E102E424599B0AB77061836A0@namprd05.prod.outlook.com> Content-Transfer-Encoding: quoted-printable
Magnus,

Thanks for the clarification. M.

From: Magnus Hagander <magnus@hagander.net>
Date: Wednesday, February 19, 2014 = at 11:03 AM
To: Mel Llaguno <mllaguno@coverity.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Availability o= f parallel jobs option in pg_dumpall

On Wed, Feb 19, 2014 at 6:03 PM, Mel Llaguno <mllaguno@cov= erity.com> wrote:
Does anyone know if the the -j option is available for the pg_dumpall
command in PG 9.3.x? There is no reference of it in the documentation
(unlike pg_dump) which implies that pg_dumpall functions differently than pg_dump.

-j is only available for pg_dump, that is correct. It requires an outp= ut format of "directory", which is not supported by pg_dumpall.&n= bsp;


--
 Magnus Hagander
 Me: http://www= .hagander.net/
 Work: ht= tp://www.redpill-linpro.com/
 --_000_CF2A4082116F5mllagunocoveritycom_--