Re: [GENERAL] Using cp to back up a database? - Mailing list pgsql-general

From Achilleas Mantzios
Subject Re: [GENERAL] Using cp to back up a database?
Date
Msg-id f04a8889-15d2-4ca6-0c28-d320693c93c8@matrix.gatewaynet.com
Whole thread Raw
In response to Re: [GENERAL] Using cp to back up a database?  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: [GENERAL] Using cp to back up a database?
Next
From: Jeff Janes
Date:
Subject: Re: [GENERAL] Using cp to back up a database?