Re: Something else about Redo Logs disappearing

Поиск
Список
Период
Сортировка
Искать
От
Laurenz Albe
Тема
Re: Something else about Redo Logs disappearing
Дата
Msg-id
ec8d3b4c811519aa377c94f83450f046a62fd38c.camel@cybertec.at
Ответ на
Список
Дерево обсуждения
12.2: Why do my Redo Logs disappear?? Peter <pmc@citylink.dinoex.sub.org>
Re: 12.2: Why do my Redo Logs disappear?? Peter Geoghegan <pg@bowt.ie>
Re: 12.2: Why do my Redo Logs disappear?? Peter <pmc@citylink.dinoex.sub.org>
Re: 12.2: Why do my Redo Logs disappear?? Adrian Klaver <adrian.klaver@aklaver.com>
Re: 12.2: Why do my Redo Logs disappear?? Adrian Klaver <adrian.klaver@aklaver.com>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Adrian Klaver <adrian.klaver@aklaver.com>
Re: Something else about Redo Logs disappearing Stephen Frost <sfrost@snowman.net>
Re: Something else about Redo Logs disappearing Adrian Klaver <adrian.klaver@aklaver.com>
Re: Something else about Redo Logs disappearing Stephen Frost <sfrost@snowman.net>
Re: Something else about Redo Logs disappearing Stephen Frost <sfrost@snowman.net>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Stephen Frost <sfrost@snowman.net>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Stephen Frost <sfrost@snowman.net>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Stephen Frost <sfrost@snowman.net>
Re: Something else about Redo Logs disappearing Magnus Hagander <magnus@hagander.net>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Magnus Hagander <magnus@hagander.net>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Laurenz Albe <laurenz.albe@cybertec.at>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Laurenz Albe <laurenz.albe@cybertec.at>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Laurenz Albe <laurenz.albe@cybertec.at>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Laurenz Albe <laurenz.albe@cybertec.at>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Laurenz Albe <laurenz.albe@cybertec.at>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Laurenz Albe <laurenz.albe@cybertec.at>
Re: Something else about Redo Logs disappearing Adrian Klaver <adrian.klaver@aklaver.com>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Stephen Frost <sfrost@snowman.net>
Re: Something else about Redo Logs disappearing Adrian Klaver <adrian.klaver@aklaver.com>
Re: Something else about Redo Logs disappearing Magnus Hagander <magnus@hagander.net>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Tom Lane <tgl@sss.pgh.pa.us>
Re: Something else about Redo Logs disappearing Peter <pmc@citylink.dinoex.sub.org>
Re: Something else about Redo Logs disappearing Adrian Klaver <adrian.klaver@aklaver.com>
On Mon, 2020-06-15 at 14:50 +0200, Peter wrote:
> ! An example:
> ! 
> ! - Backup #1 calls "pgpre.sh"
> ! - Backup #1 starts copying files
> ! - Backup #2 calls "pgpre.sh".
> !   This will cancel the first backup.
> ! - Backup #1 completes copying files.
> ! - Backup #1 calls "pgpost.sh".
> !   It will receive an error.
> !   So it has to invalidate the backup.
> ! - Backup #2 completes copying files.
> ! - Backup #2 calls "pgpost.sh".
> !   It gets a "backup_label" file and completes the backup.
> 
> That's not true.

Ah, yes, you are right.
It's a while since I wrote these scripts.

Since "pgpre.sh" and "pgpost.sh" are independent, there
is no way to tell which of them belongs to which other.

So calling "pgpost.sh" indeed ends the most recently started
backup and returns "backup_label" accordingly.

That means: the caller of the scripts has to make sure
not to start a second backup while the first one is running.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com



В списке pgsql-general по дате отправления
От: Peter
Дата:
От: Sonam Sharma
Дата:
Сообщение: Replication error
FAQ