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@xxxxxxxxxxx
