On Thu, Feb 8, 2024, 17:05 Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:
> (PG 14, if it matters.)
>
> What's the purpose of fetch mode, as opposed to streaming mode? Is it a
> legacy of bygone days that just hasn't been deprecated, or is there
> something I don't understand from reading
> https://www.postgresql.org/docs/14/app-pgbasebackup.html?
>
Your backup can go to a single file with it, which it can't do in
streaming. Which means it can also be sent through a pipe.
It also needs one connection instead of two to the server, if that's
limited.
/Magnus