public inbox for [email protected]  

help / color / mirror / Atom feed

pg_dump documentation page
3+ messages / 3 participants
[nested] [flat]

* pg_dump documentation page
@ 2020-01-30 01:26 PG Doc comments form <[email protected]>
  2020-01-30 09:41 ` Re: pg_dump documentation page Laurenz Albe <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: PG Doc comments form @ 2020-01-30 01:26 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]

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.


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pg_dump documentation page
  2020-01-30 01:26 pg_dump documentation page PG Doc comments form <[email protected]>
@ 2020-01-30 09:41 ` Laurenz Albe <[email protected]>
  2020-01-30 12:55   ` Re: pg_dump documentation page Daniel Gochin <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Laurenz Albe @ 2020-01-30 09:41 UTC (permalink / raw)
  To: [email protected]; [email protected]

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






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pg_dump documentation page
  2020-01-30 01:26 pg_dump documentation page PG Doc comments form <[email protected]>
  2020-01-30 09:41 ` Re: pg_dump documentation page Laurenz Albe <[email protected]>
@ 2020-01-30 12:55   ` Daniel Gochin <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Daniel Gochin @ 2020-01-30 12:55 UTC (permalink / raw)
  To: Laurenz Albe <[email protected]>; +Cc: [email protected]

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, <[email protected]> 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
>
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2020-01-30 12:55 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-01-30 01:26 pg_dump documentation page PG Doc comments form <[email protected]>
2020-01-30 09:41 ` Laurenz Albe <[email protected]>
2020-01-30 12:55   ` Daniel Gochin <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox