Re: Avoiding data loss with synchronous replication - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Avoiding data loss with synchronous replication
Date
Msg-id 20210725002906.paofuuhjxgof6uns@alap3.anarazel.de
Whole thread Raw
In response to Re: Avoiding data loss with synchronous replication  (Andrey Borodin <x4mmm@yandex-team.ru>)
Responses Re: Avoiding data loss with synchronous replication  (Andrey Borodin <x4mmm@yandex-team.ru>)
List pgsql-hackers
Hi,

On 2021-07-24 15:53:15 +0500, Andrey Borodin wrote:
> Are there any other problems with blocking cancels?

Unless you have commandline access to the server, it's not hard to get
into a situation where you can't change the configuration setting
because all connections are hanging, and you can't even log in to do an
ALTER SERVER etc. You can't kill applications to kill the connection,
because they will just continue to hang.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Avoiding data loss with synchronous replication
Next
From: Andres Freund
Date:
Subject: Re: Removing "long int"-related limit on hash table sizes