| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: More efficient pg_restore method? |
| Date: | 2018-08-30 17:30:27 |
| Message-ID: | ee4c5ab8-f86e-c101-5533-3dc946f794f5@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rydzewski | 2018-09-01 01:57:56 | Archive to secondary Postgres instance |
| Previous Message | Bear Giles | 2018-08-30 14:41:10 | Re: FW: Setting up SSL for postgre |