Re: [GENERAL] pg_start/stop_backup non-exclusive scripts to snapshot - Mailing list pgsql-general

From Michael Paquier
Subject Re: [GENERAL] pg_start/stop_backup non-exclusive scripts to snapshot
Date
Msg-id CAB7nPqTKapELC9OLapfo+a8RhQB1SdqHv=TKUZ7xQsuzvXhQLQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] pg_start/stop_backup non-exclusive scripts to snapshot  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: [GENERAL] pg_start/stop_backup non-exclusive scripts to snapshot  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
On Wed, Jul 5, 2017 at 10:47 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
> Your criticism is noted, however, I have used it many times in the past with absolutely no problem.

Plug off the server on which is stored the backup just after your
script finishes, you have a good chance to be surprised if you try to
restore from this backup later on.

> I submitted that script as a possible solution
> to the op's problem/question. If you have an alternate solution or can make improvements to it, then I am sure the op
andI would welcome them. 

Stephen has mentioned two of them, with hundreds of man hours spent in
developing those backup tools to be robust solutions, done by
specialists on the matter.
--
Michael


pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: [GENERAL] Strange case of database bloat
Next
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] Imperative Query Languages