Re: 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(at)arcict(dot)com <mailto:info(at)arcict(dot)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(dot)klaver(at)aklaver(dot)com