On 08/28/2018 11:48 AM, Ron wrote:
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.)
Turns out that pushing the data over port 5432 is about 3x faster than
pulling it across nfs (at least when a WAN is involved).
--
Angular momentum makes the world go 'round.
