Answer the question
In order to leave comments, you need to log in
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
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.
The custom format (compared to plaintext) supports multi-threaded recovery - this is its main advantage. Directory archives better and is easier to edit.
directory is the only format that supports multi-threaded dumping
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question