Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] Fastest Backup Method? - Mailing list pgsql-admin

From Artem Tomyuk
Subject [ADMIN] Fastest Backup Method?
Date
Msg-id CANYYVq+mMcG4CaDaXaw1forru51VH_rA3ahR+1c++62ipZN5Kw@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] Fastest Backup Method?  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-admin
Tree view
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 

pgsql-admin by date:

Previous
From: Siva Kandasamy
Date:
Subject: Re: [ADMIN] New to postgreSQL
Next
From: "Jean R. Franco"
Date:
Subject: Re: [ADMIN] pgdump and restore results in different sizes DB