Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump - how to force to show timestamps in client log - Mailing list pgsql-general

From Joshua Drake
Subject Re: pg_dump - how to force to show timestamps in client log
Date
Msg-id CAJvJg-T0nK3ZtRqBcvKnK-wq=tt+CoQGy-Mp=DVaw82tdjWTRg@mail.gmail.com
Whole thread Raw
In response to pg_dump - how to force to show timestamps in client log  (Durumdara <durumdara@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Durumdara
Date:
Subject: pg_dump - how to force to show timestamps in client log
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump - how to force to show timestamps in client log