Обсуждение: 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>
> 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