Re: pg_dump - increase in backup time - log

2021-08-27 Thread Tom Lane
Adrian Klaver 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

Re: pg_dump - increase in backup time - log

2021-08-27 Thread Adrian Klaver
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 i

pg_dump - increase in backup time - log

2021-08-27 Thread Marc
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