Обсуждение: pg_dump - increase in backup time - log
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.
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.
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 | www.arcict.com |
tel. : +32 (0)2 466 50 00 | fax. : +32 (0)2 466 88 33 |
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