On Mon, Jun 10, 2024 at 6:21 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
> Magnus Hagander <mag...@hagander.net> writes: > > On Mon, Jun 10, 2024 at 5:03 PM Nathan Bossart <nathandboss...@gmail.com > > > > wrote: > >> Is there a particular advantage to that approach as opposed to just > using > >> "directory" mode for everything? > > > A gazillion files to deal with? Much easier to work with individual > custom > > files if you're moving databases around and things like that. > > Much easier to monitor eg sizes/dates if you're using it for backups. > > You can always tar up the directory tree after-the-fact if you want > one file. Sure, that step's not parallelized, but I think we'd need > some non-parallelized copying to create such a file anyway. > That would require double the disk space. But you can also just run pg_dump manually on each database and a pg_dumpall -g like people are doing today -- I thought this whole thing was about making it more convenient :) -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
