Re: In case of network issues, how long before archive_command does retries

2022-05-20 Thread Koen De Groote
Thank you for your thorough explanation. On Thu, May 19, 2022 at 5:47 PM Laurenz Albe wrote: > On Thu, 2022-05-19 at 15:43 +0200, Koen De Groote wrote: > > On Thu, May 19, 2022 at 9:10 AM Laurenz Albe > wrote: > > > On Wed, 2022-05-18 at 22:51 +0200, Koen De Groote wrote: > > > > When connectio

Re: Long living and expiring locks?

2022-05-20 Thread Laurenz Albe
On Fri, 2022-05-20 at 15:43 +1200, Tim Uckun wrote: > I have multiple processes connecting to the same database. In order to > prevent race conditions the I would like the process to  issue a > SELECT FOR UPDATE  to lock the records that need to be processed. > > The problem is that the locks are