Pg 9.6.9 on Linux...Given a backup server storing a "format=directory" database backup, and a database server, should I:
Option #1: run pg_restore on the backup server and "push" the data to the database server via port 5432, or Option #2: have the backup server serve the dump directory via NFS, and run pg_restore on the database server, pulling the data via nfs protocol?
(It'll be a multi-threaded restore over a 10Gb pipe.) -- Angular momentum makes the world go 'round.