J
J
Jorik_Wa2017-11-15 16:15:37
PostgreSQL
Jorik_Wa, 2017-11-15 16:15:37

In what format is it better to make backups in pgdump?

In what format is it better to make backups in pgdump? Custom, directory.... Or shouldn't you bother?
Now I'm doing it in custom

Answer the question

In order to leave comments, you need to log in

3 answer(s)
T
TyzhSysAdmin, 2017-11-15
@POS_troi

In principle, the question here is "the color of the felt-tip pens."
It depends on the preferences and size of the database, and the choice is actually not great, only two positions:
1. Plain
2. custom / directory / tar
1st, the most clumsy and simple
2nd is universal and with buns, in fact everything is the same and the same difference in compression.

K
ky0, 2017-11-15
@ky0

The custom format (compared to plaintext) supports multi-threaded recovery - this is its main advantage. Directory archives better and is easier to edit.

I
Ivan Sobolev, 2017-11-23
@banek13

directory is the only format that supports multi-threaded dumping

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question