From: | Ninad Shah <nshah(dot)postgres(at)gmail(dot)com> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Issue with pg_basebackup v.11 |
Date: | 2021-10-22 15:40:31 |
Message-ID: | CAOFEiBc21S_CBaw4qHB5S-j3ty00CV21T8SMt8SvYFKEJnFDVA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2021-10-22 15:49:28 | Re: Looking for a doc section that presents the overload selection rules |
Previous Message | Laurenz Albe | 2021-10-22 15:20:55 | Re: [Major version upgrade] pg_upgrade fails despite passing check mode |