More efficient pg_restore method? - Mailing list pgsql-admin

From Ron
Subject More efficient pg_restore method?
Date
Msg-id 44555188-c787-b441-5c69-c56f72905bf4@gmail.com
Whole thread Raw
Responses Re: More efficient pg_restore method?  (Evan Bauer <evanbauer@mac.com>)
Re: More efficient pg_restore method?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: Christoph Berg
Date:
Subject: Re: Index corruption after pg_basebackup
Next
From: wambacher@posteo.de
Date:
Subject: Re: tuple concurrently updated