Horton

RE: pg_basebackup -F t fails when fsync spends more time than tcp_user_timeout

Ryohei Takahashi (Fujitsu) <r.takahashi_2@fujitsu.com>

View thread View on postgr.es
From: "r.takahashi_2@fujitsu.com" <r.takahashi_2@fujitsu.com>
To: 'Michael Paquier' <michael@paquier.xyz>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2019-09-02T08:06:22Z
Lists: pgsql-hackers 
Hi Michael-san,


> Attached is a patch to do that, which should go down to v12 where
> tcp_user_timeout has been introduced.  Takahashi-san, what do you
> think?

Thank you for creating the patch.
This patch is what I expected.

I'm not sure whether this patch should be applied to postgres below 11
since I'm not sure whether the OS parameters (ex. tcp_retries2) cause the same error.

Regards,
Ryohei Takahashi

Commits

  1. Delay fsyncs of pg_basebackup until the end of backup