From: Tom Lane <tgl@sss.pgh.pa.us>
To: tomas.dalebjork@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16842: pg_dump uses seek calls on pipe files: suggesting adding a flag to disable seek calls
Date: Thu, 28 Jan 2021 10:32:46 -0500
Message-ID: <2546666.1611847966@sss.pgh.pa.us> (raw)
In-Reply-To: <16842-381bd64d2f0f68db@postgresql.org>
References: <16842-381bd64d2f0f68db@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> It would be good to add a flag to disable this feature, as some devices does
> not support seek calls, for example streaming devices such as a tape
> drive.
That seems like an extremely niche use-case, so I'm unexcited about adding
a switch for it. You can get the same results with a pipe, as your quoted
response from Red Hat support suggests.
Note that disabling seeking is not all that desirable in the first place,
as it will result (for -Fc output) in a dump file that is significantly
restrictive to restore performance, due to lack of data offset pointers.
You might really be best advised to rethink whether you want to write
directly to an unseekable device, rather than to a temp file you transfer
to tape later.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, tomas.dalebjork@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16842: pg_dump uses seek calls on pipe files: suggesting adding a flag to disable seek calls
In-Reply-To: <2546666.1611847966@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox