| From: | Joshua Drake <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Durumdara <durumdara(at)gmail(dot)com> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_dump - how to force to show timestamps in client log |
| Date: | 2020-11-20 20:32:30 |
| Message-ID: | CAJvJg-T0nK3ZtRqBcvKnK-wq=tt+CoQGy-Mp=DVaw82tdjWTRg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmail(dot)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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-11-20 20:56:35 | Re: pg_dump - how to force to show timestamps in client log |
| Previous Message | Durumdara | 2020-11-20 18:01:47 | pg_dump - how to force to show timestamps in client log |