On 09/10/2017 17:13, Michael Paquier wrote:
> On Mon, Oct 9, 2017 at 11:09 PM, Achilleas Mantzios
> <achill@matrix.gatewaynet.com> 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
waitfor that long.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general