On 09/10/2017 17:13, Michael Paquier wrote:
On Mon, Oct 9, 2017 at 11:09 PM, Achilleas Mantzios
<achill@xxxxxxxxxxxxxxxxxxxxx> wrote:
In all pg conferences I have been, ppl scream : do not use pg_dump for
backups :)
It depends on what you are trying to achieve, pg_dump can be fine for
small-ish databases. By relying on both logical (pg_dump) and physical
backups (base backups) brings more insurance in face of a disaster.
Basically yes, it depends on size. Where I work in order to do a proper pg_dump would take ~ one week. Business can't wait for that long.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
