Re: In case of network issues, how long before archive_command does retries - Mailing list pgsql-general

From Laurenz Albe
Subject Re: In case of network issues, how long before archive_command does retries
Date
Msg-id 83b1f99e797754fa8f5589d458c5d3aa674479c8.camel@cybertec.at
Whole thread Raw
In response to In case of network issues, how long before archive_command does retries  (Koen De Groote <kdg.dev@gmail.com>)
Responses Re: In case of network issues, how long before archive_command does retries
List pgsql-general
On Wed, 2022-05-18 at 22:51 +0200, Koen De Groote wrote:
> I've got a setup where archive_command will gzip the wal archive to a directory that is itself an NFS mount.
> 
> When connection is gone or blocked, archive_command fails after the timeout specified by the NFS mount, as expected.
(fora soft mount. hard mount hangs, as expected)
 
> 
> However, on restoring connection, it's not clear to me how long it takes before the command is retried.
> 
> Experience says "a few minutes", but I can't find documentation on an exact algorithm.
> 
> To be clear, the question is: if archive_command fails, what are the specifics of retrying? Is there a timeout? How
isthat timeout defined?
 
> 
> Is this detailed somewhere? Perhaps in the source code? I couldn't find it in the documentation.
> 
> For detail, I'm using postgres 11, running on Ubuntu 20.

You can find the details in "src/backend/postmaster/pgarch.c".

The archiver will try to archive three times (NUM_ARCHIVE_RETRIES) in an interval
of one second, then back off until it receives a signal, PostgreSQL shutd down
or a minute has passed.

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



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: About pg_basebackup
Next
From: Dominique Devienne
Date:
Subject: No default for (user-specific) service file location on Windows?