pg_dump documentation page
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/app-pgdump.html
Description:
Hi,
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
Thanks,
Daniel.
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
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, <laurenz.albe@cybertec.at> wrote:
Show quoted text
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 mentionthat
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