Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ix9Zy-0005L6-HO for pgsql-docs@arkaria.postgresql.org; Thu, 30 Jan 2020 13:09:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ix9Zx-00089z-Bg for pgsql-docs@arkaria.postgresql.org; Thu, 30 Jan 2020 13:09:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ix9MM-000757-To for pgsql-docs@lists.postgresql.org; Thu, 30 Jan 2020 12:55:51 +0000 Received: from mail-io1-xd31.google.com ([2607:f8b0:4864:20::d31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ix9MG-0006PV-3L for pgsql-docs@lists.postgresql.org; Thu, 30 Jan 2020 12:55:49 +0000 Received: by mail-io1-xd31.google.com with SMTP id x1so3841822iop.7 for ; Thu, 30 Jan 2020 04:55:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=2V+/D12+YNevr3Ik12017nv/UiOAIN40EwE7nhbPLjE=; b=TxpIQ6/UA2Q1/2k2Lj27dC7zzey01geN1aKyBwFcUQbwg+UN8FD54SdUfHcyHtqnAM fX1LODTLBBj9lq+4KaTPWj/hvh+iHdyZViA0eechXKK48liUDgsgWviuSp9KPjexdyWw +S8MNJD0KmfALjie3Rrxx6tDEwMaileRaQVNMjOo29laYQvpGF3oB2h/KttlW+8c+4Vo WxNMn7qL0PX9JVbchE9HCCL05aqG1m6guU5cKgVN2+X6SeqL0SBF6gBn/neJCsrD2//L reAmoMFj6i0jKbW+6nULKR3IfTooSmT/BXTBL1irIyeN1oNH9B5gH8Lm25GfQwmlEqUg vA8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=2V+/D12+YNevr3Ik12017nv/UiOAIN40EwE7nhbPLjE=; b=jelPgFKCQw0cPzao8R/xajDrsyx00zTkPeidyqc7tEJ/QsR3CNJKy3aOS2uugoUeVI +Kb5e9xeJj13MFFZBiX5Mhaf7stkhojbP7aWyitL1f894h2iednG1qAjxSppdER2gciu tdoEsqlbEHyiemNvpkwRlh69F6hDVUL2G4bTkv1h7YHnBk7u6rrOQ96SrbX0IaGlWt/h wuWCmZTPXIvIvZOAxwW7FqN5tul8vMFu267jlELBhXf26Dmc/qJC6cPv02XV7VtQbTbR zCVRS2mTnD8FyE3tFI/5TBDZPNQ/GOu1iYgBj/DSjCfLUcENXCETOWHofYJjG52nDdZO TAiA== X-Gm-Message-State: APjAAAXIpTT3Dh9CwcWMNVeIJ5nRpeog2rD3WPftYNZvp5R5RD1VaZZ1 6iaMFd3IizQCN3iIAhq5EWOQYnoLxchjQsODOkp7c7Sy X-Google-Smtp-Source: APXvYqz1wCefYRDM095TDcRp4d8b4fue0T1Y0BeBh132MDxF8/KVfJEARgHhWcNc92WUn/QZdrDoCpiMqeLLSddthPo= X-Received: by 2002:a5e:d602:: with SMTP id w2mr3764518iom.94.1580388943128; Thu, 30 Jan 2020 04:55:43 -0800 (PST) MIME-Version: 1.0 References: <158034760940.19847.4196894870089947531@wrigleys.postgresql.org> In-Reply-To: From: Daniel Gochin Date: Thu, 30 Jan 2020 23:55:30 +1100 Message-ID: Subject: Re: pg_dump documentation page To: Laurenz Albe Cc: pgsql-docs@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000008fedef059d5af96d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000008fedef059d5af96d Content-Type: text/plain; charset="UTF-8" Hi Laurenz, Regarding the first point, I can't believe I missed it. Sorry for wasting your time and thanks for pointing it out. Regarding the second point, if you are using the -F d switch, you may not necessarily look at the -f switch, which is what happened to me at first. Would it not be more explicit if under the -F d switch it said something like, you need to use -f switch in order to specify the directory to be used. Thanks! Daniel. On Thu, 30 Jan 2020, 8:41 pm Laurenz Albe, wrote: > On Thu, 2020-01-30 at 01:26 +0000, PG Doc comments form wrote: > > I'm not certain but I think that on the page: > > https://www.postgresql.org/docs/9.6/app-pgdump.html, it should mention > that > > to use the -j (jobs) switch, you can only use -F d (format directory.) > > Also, when using -F d, you need to use the -f (file) switch as well to > > specify the directory name. I didn't find that to be clear. > > > > e.g.: pg_dump -j 5 -Fd -f "c:\pg backup" test_db > > It says right there: > > At the -j option: > > "You can only use this option with the directory output format because > this is the only > output format where multiple processes can write their data at the same > time." > > At the -f option: > > "This parameter can be omitted for file based output formats, in which > case the standard > output is used. It must be given for the directory output format however, > where it > specifies the target directory instead of a file. > > Yours, > Laurenz Albe > -- > Cybertec | https://www.cybertec-postgresql.com > > --0000000000008fedef059d5af96d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
H= i=C2=A0Laurenz,

Regarding the first point, I can't believe I missed i= t. Sorry for wasting your time and thanks for pointing=C2=A0it out.

Regard= ing the second point, if you are using the -F d switch, you may not necessa= rily look at the -f switch, which is what happened to me at first. Would it= not be more explicit if under the -F d switch it said something like, you = need to use -f switch in order to specify the directory to be used.=C2=A0
= Thanks!
Daniel.=C2=A0

On = Thu, 30 Jan 2020, 8:41 pm Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
On Thu, 2020-01-30 at 01:26 +0000, PG Doc comments form w= rote:
> I'm not certain but I think that on the page:
> https://www.postgresql.org/docs/9= .6/app-pgdump.html, it should mention that
> to use the -j (jobs) switch, you can only use -F d (format directory.)=
> Also, when using -F d, you need to use the -f (file) switch as well to=
> specify the directory name. I didn't find that to be clear.
>
> e.g.: pg_dump -j 5 -Fd -f "c:\pg backup" test_db

It says right there:

At the -j option:

"You can only use this option with the directory output format because= this is the only
=C2=A0output format where multiple processes can write their data at the sa= me time."

At the -f option:

"This parameter can be omitted for file based output formats, in which= case the standard
=C2=A0output is used. It must be given for the directory output format howe= ver, where it
=C2=A0specifies the target directory instead of a file.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

--0000000000008fedef059d5af96d--