Issue with pg_basebackup v.11 - Mailing list pgsql-general

From Ninad Shah
Subject Issue with pg_basebackup v.11
Date
Msg-id CAOFEiBc21S_CBaw4qHB5S-j3ty00CV21T8SMt8SvYFKEJnFDVA@mail.gmail.com
Whole thread Raw
Responses Re: Issue with pg_basebackup v.11
List pgsql-general
Hello experts,

I am facing an issue with a customer's production server while trying to take backup using pg_basebackup.

Below is the log from pg_basebackup execution.

* 115338208/1304172127 kB (8%), 0/1 tablespace (...atastaging/base/115868/154220.1)
 115355616/1304172127 kB (8%), 0/1 tablespace (...atastaging/base/115868/154220.1)
 115372640/1304172127 kB (8%), 0/1 tablespace (...atastaging/base/115868/154220.1)
 115389568/1304172127 kB (8%), 0/1 tablespace (...atastaging/base/115868/154220.1)
 115405792/1304172127 kB (8%), 0/1 tablespace (...atastaging/base/115868/154220.1)
 115423776/1304172127 kB (8%), 0/1 tablespace (...atastaging/base/115868/154220.1)
 115440640/1304172127 kB (8%), 0/1 tablespace (...atastaging/base/115868/154220.2)
 115454656/1304172127 kB (8%), 0/1 tablespace (...atastaging/base/115868/154220.2)
pgbasebackup: could not read COPY data: could not receive data from server: Connection timed out
pgbasebackup: removing contents of data directory "/u01/PostgreSQL/11/datastaging"*

It copied nearly 110 GB of data and exited. Initially, we suspected it as a network/OS issue. However, we tried to copy a 150 GB large file over the network, which finished successfully.

What I observed is that it takes a couple of hours between below 2 lines.

 115454656/1304172127 kB (8%), 0/1 tablespace (...atastaging/base/115868/154220.2)
pgbasebackup: could not read COPY data: could not receive data from server: Connection timed out

In other words, it run for an hour, and later, it takes 2 hours before it times out.

Can someone please help me out here?


Regards,
Ninad Shah

pgsql-general by date:

Previous
From: Ninad Shah
Date:
Subject: Re: spannerdb migration to PostgreSQL
Next
From: Adrian Klaver
Date:
Subject: Re: Looking for a doc section that presents the overload selection rules