pg_dump - increase in backup time - log

On 8/27/21 8:27 AM, Marc wrote:

Hello,

Suddenly the time required to backup with pg_dump increased suddenly
drastically ( + 20min on a backuptime of 2 hours ) no comparable
increase of data which could explain the behaviour.

What is the pg_dump command you are using?

We want to dig into it but we lack a detailled pg_dump log. We used
verbose mode but unfortunately this lacks a date time stamp.
No changes on the server neither.

The Postgres server log should have timestamped log entries though.

Postgres: version 11.13
pg_dump is running on the same machine as Postgres and no changes have
been made to the configuration

Any ideas/help most welcome,
Thanks in advance,

Marc

*ARC - your Apple Authorised Service partner* H.D. Saviolaan 8
B-1700 Dilbeek
Belgium
info@arcict.com <mailto:info@arcict.com> www.arcict.com
<http://www.arcict.com&gt;
tel. : +32 (0)2 466 50 00 fax. : +32 (0)2 466 88 33

--
Adrian Klaver
adrian.klaver@aklaver.com

Adrian Klaver <adrian.klaver@aklaver.com> writes:

On 8/27/21 8:27 AM, Marc wrote:

We want to dig into it but we lack a detailled pg_dump log. We used
verbose mode but unfortunately this lacks a date time stamp.
No changes on the server neither.

The Postgres server log should have timestamped log entries though.

Yeah, turn on log_statement = all on the server and watch what pg_dump
is doing that way.

regards, tom lane