Re: [GENERAL] Associating a basebackup and it's .backup WAL file - Mailing list pgsql-general

From Stephen Frost
Subject Re: [GENERAL] Associating a basebackup and it's .backup WAL file
Date
Msg-id 20170713225341.GK1769@tamriel.snowman.net
Whole thread Raw
In response to Re: [GENERAL] Associating a basebackup and it's .backup WAL file  (cen <imbacen@gmail.com>)
List pgsql-general
Greetings,

* cen (imbacen@gmail.com) wrote:
> Seems like a lot of manual work to me, to automate it I'd basically
> have to diff both directories and then copy only the newest
> differences over to the recovery. So far I was unable to find a
> supersecret git repo with bash scripts accomplishing this tasks
> which is surprising.

I would hazard to suggest that's because people have realized that bash
scripting backup and recovery of PostgreSQL, and ensuring that all of
the appropriate precautions are taken and checks are done, is next to
impossible; were it to be done the scripts would be more complex and
challenging to use than any of the existing solutions.

I'd strongly suggest you consider one of the maintained backup solutions
that have already been written instead of inventing yet another one.

Thanks!

Stephen

Attachment

pgsql-general by date:

Previous
From: cen
Date:
Subject: Re: [GENERAL] Associating a basebackup and it's .backup WAL file
Next
From: Stephen Frost
Date:
Subject: Re: [GENERAL] LDAP authentication without OU in ldapbasedn