Fastest Backup Method?

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Fastest Backup Method?
Date: 2017-09-04 17:23:30
Message-ID: CANYYVq+mMcG4CaDaXaw1forru51VH_rA3ahR+1c++62ipZN5Kw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi.

I'am wondering, what is the fastest backup method do you know, for me it is:
(Assume that we running on 16 * CPU box)

pg_dump -Z 4 -j 16 -F c -F d

-Z 4 compression level

-j 16 number of parallel jobs

-F c, d custom+directory format

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jean R. Franco 2017-09-04 18:15:30 Re: pgdump and restore results in different sizes DB
Previous Message Siva Kandasamy 2017-09-04 16:52:19 Re: New to postgreSQL