Re: pg_dump - how to force to show timestamps in client log

Поиск
Список
Период
Сортировка
От Joshua Drake
Тема Re: pg_dump - how to force to show timestamps in client log
Дата
Msg-id CAJvJg-T0nK3ZtRqBcvKnK-wq=tt+CoQGy-Mp=DVaw82tdjWTRg@mail.gmail.com
обсуждение исходный текст
Ответ на pg_dump - how to force to show timestamps in client log  (Durumdara <durumdara@gmail.com>)
Список pgsql-general
Дерево обсуждения
Howdy,

pg_dump is just issuing SQL commands, you could turn on timestamps in your postgresql log.

JD

On Fri, Nov 20, 2020 at 10:02 AM Durumdara <durumdara@gmail.com> wrote:
Hello!

We need to log the pg_dump's state.
What objects are in copy, and what are the starting and ending times.

But when I try to redirect the output, the result doesn't have timestamps.

PG 11, on Windows.

As I see the -v option isn't enough to see the starting times.

For example:

2020-11-19 12:00:01.084 Dump table content table1
2020-11-19 12:03:12.932 Dump table content table2
...
etc.  


Thank you for any information you can provide!

dd


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