pg_dump - how to force to show timestamps in client log

From: Durumdara <durumdara(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: pg_dump - how to force to show timestamps in client log
Date: 2020-11-20 18:01:47
Message-ID: CAEcMXhkrsYX3W-Co1dGasVv-qoCcpJRJFE9Dx+ww4HmvrvZz_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua Drake 2020-11-20 20:32:30 Re: pg_dump - how to force to show timestamps in client log
Previous Message David G. Johnston 2020-11-20 17:53:34 Re: Determine if postgresql cluster running is primary or not