Re: More efficient pg_restore method?

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.