Re: pg_dump - increase in backup time - log

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: pg_dump - increase in backup time - log
Дата
Msg-id c6b99405-e50e-f14b-6d54-35bcd99c40ae@aklaver.com
обсуждение исходный текст
Ответ на pg_dump - increase in backup time - log  (Marc <postgres@arcict.com>)
Ответы Re: pg_dump - increase in backup time - log  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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



В списке pgsql-general по дате отправления:

Предыдущее
От: Blake McBride
Дата:
Сообщение: Please help: pgAdmin 4 on Amazon Linux 2
Следующее
От: Mike Martin
Дата:
Сообщение: Re: Problem with connecting with named host parameter