Re: Backup From HotStandby

Поиск
Список
Период
Сортировка
От Licio Matos
Тема Re: Backup From HotStandby
Дата
Msg-id CAK6Tc4OZYGKPCmstHiDjtY=NqvZ49J4A=keCQ=j102yBGxUB3A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Backup From HotStandby  (Rui DeSousa <rui@crazybean.net>)
Список pgsql-admin
@Rui DeSousa 

Tks again, i will try this aproach or alter the script to do with the pg_basebackup.

Tks a lot guys.

Licio Matos




Em qua, 28 de ago de 2019 às 17:38, Rui DeSousa <rui@crazybean.net> escreveu:


On Aug 28, 2019, at 4:11 PM, Licio Matos <licio.matos@gmail.com> wrote:

@Rui DeSousa 

I am running this on the primary, the question is if i can run this same script on the replica.


You can based on what you told me about the snapshot; however, the pg_start_backup() command will fail.  

Note: What you are doing today most would consider it a “proper” online backup; when you start running the script on the replica then you will end up with a “crashed” backup.   The “crashed” backup only works as you can guarantee a point in time atomic view of all the data files using a single atomic snapshot.

You need to remove the pg_start_backup() and pg_stop_backup() commands from the script.   The backup should occur faster as it is no longer waiting on pg_start_backup() to issue checkpoint; however, that also means that recovery times increase for the same reason.  

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rui DeSousa
Дата:
Сообщение: Re: Backup From HotStandby
Следующее
От: John Scalia
Дата:
Сообщение: Index not always being used