Search Postgresql Archives

Re: Something else about Redo Logs disappearing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Jun 11, 2020 at 10:53:15PM +0200, Laurenz Albe wrote:
! On Thu, 2020-06-11 at 22:35 +0200, Magnus Hagander wrote:
! > I believe somebody around that time also wrote a set of bash scripts that can be used in a pre/post-backup-job combination with the current APIs.
! 
! https://github.com/cybertec-postgresql/safe-backup

Ah, thank You, very nice.

I've never seen anybody coding bash - it is strongly shunned in the
Berkeley community. 

Some Questions:
 1. There are explicit error messages in loc-82 and -92 of pgpre.sh.
    To where are these written?
 2. The result data from pg_stop_backup() are stored into the living
    database. But, according to the docs, they should be placed into
    the completed backup. Do I have a misunderstanding here?
 3. The most common error cause of a backup might be tape-side
    malfunction. So far as I see, the way to handle this is currently,
    to provide a timeout for pgpre.sh (which is problematic, because
    we might as well have just reached end-of-tape and have to wait
    until monday for the operator to change it). May I suggest to add
    a switch to pgpost.sh, in order to volutarily fail out of the job?
 4. If, by misconfiguration and/or operator error, the backup system
    happens to start a second backup. in parallel to the first,
    then do I correctly assume, both backups will be rendered
    inconsistent while this may not be visible to the operator; and
    the earlier backup would be flagged as apparently successful while
    carrying the wrong (later) label?

BTW: what does, in general, happen, if a backup_label file gets
accidentially swapped with one from a parallel, but slightly later
backup? Do I correctly assume that such mistake gets somehow detected,
as otherwise it would have just the same unwelcome effects
(i.e. silent data corruption) as no backup_label at all?

cheerio,
PMc





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux