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

On 11/20/20 10:01 AM, Durumdara 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.

If you are redirecting to a file it have the creation time that you can
use. Internally times don't really matter for the objects as the dump is
based on a snapshot. Said snapshot is based on visible transactions not
time. So for practical purposes they all occur at the same 'time'.

>
>
> Thank you for any information you can provide!
>
> dd
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com