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.klaver@aklaver.com