(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?