From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Using cp to back up a database? |
Date: | 2017-10-09 14:20:36 |
Message-ID: | f04a8889-15d2-4ca6-0c28-d320693c93c8@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 09/10/2017 17:13, Michael Paquier wrote:
> On Mon, Oct 9, 2017 at 11:09 PM, Achilleas Mantzios
> <achill(at)matrix(dot)gatewaynet(dot)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 wait for that long.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2017-10-09 16:33:27 | Re: Using cp to back up a database? |
Previous Message | Ron Johnson | 2017-10-09 14:15:15 | Re: Using cp to back up a database? |