pg_back icon indicating copy to clipboard operation
pg_back copied to clipboard

Published 20 hours ago • verified publisher icon orgrim

Support of FORMAT binary (bytea problem)

Open Krysztophe opened this issue 2 years ago • 0 comments

  • Big bytea fields (> a few 100MBs) cannot be exported (famous old limitation)
  • pg_dumpbinary uses COPY ... TO ... (FORMAT binary) but has very few features.
  • Is it possible that pg_back covers this case? A parameter may contain tables to be dumped with FORMAT binary. I suppose that coherence may be a problem (or use --snapshot ?) And it would need a separate restore script.

Krysztophe avatar Nov 14 '22 14:11 Krysztophe