Re: Upgrading 6 versions between 2 systems

On Mon, 14 Sep 2026, Ron Johnson wrote:

> Yes. Note, though, that a single .sql file is the *slow* way to
> export/import a database, especially if it's of any size.

Ron,

My databases are small and I'll transfer them one-at-a-time rather than the
whole custer itself.

> Multithreaded export import is faster. Something like this is what I'd do:
>
> Current system:
> cd /path/to/backups
> pg_dumpall --globals-only > globals_127.sql
> Zlvl="--compress=zstd"
> Threads=4 # or whatever
> for db in x, y, z; do
> pg_dump -p5432 -Fd $Zlvl -v --jobs=$Threads -f $db $db
> done
>
> New system:
> cd /path/to/backups
> psql -af globals_127.sql
> Zlvl="--compress=zstd"
> Threads=4 # or whatever
> for db in x, y, z; do
> ${pg18}/pg_restore -p5433 -v --jobs=$Threads --clean --create -Fd -d
> postgres $db
> done

Good idea.

Thanks,

Rich