More efficient pg_restore method?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: More efficient pg_restore method?
Date: 2018-08-28 16:48:48
Message-ID: 44555188-c787-b441-5c69-c56f72905bf4@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message wambacher 2018-08-28 16:54:46 Re: tuple concurrently updated
Previous Message Christoph Berg 2018-08-28 16:42:40 Re: Index corruption after pg_basebackup