Re: Queries in replica are failing

Поиск
Список
Период
Сортировка
От ROHIT SACHDEVA
Тема Re: Queries in replica are failing
Дата
Msg-id CAKDb7aGAN5h0tR0CCwOnJYtkRtwuMrYp6MH0sOdd-KWAjKhjSw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Queries in replica are failing  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Queries in replica are failing
Список pgsql-admin
Hi ,

If I set both to -1 storage space is increasing rapidly.

Any way out as they are okay with 1 day delay but queries should run smoothly.

Can I pause or schedule the replication process replication at 12 am in Postgres RDS.

On Thu, 30 May, 2024, 2:47 am Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
On Wed, 2024-05-29 at 22:34 +0530, ROHIT SACHDEVA wrote:
> I received this error when i set  max_standby_streaming_delay to -1 and max_standby_archive_delay to 30 seconds.
>
> The following processes were terminated on your read replica because they were interfering with the replay of transaction logs: [18218].

Ah, then you are recovering from an archive.

In that case, set "max_standby_archive_delay" to -1 as well.

Yours,
Laurenz Albe

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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Queries in replica are failing
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Queries in replica are failing