Re: Timestamps in outputs

From: SOzcn <selahattinozcnma(at)gmail(dot)com>
To: Murthy Nunna <mnunna(at)fnal(dot)gov>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Timestamps in outputs
Date: 2023-12-20 06:14:57
Message-ID: CAJyV5AbTtUck6hw8M090xVT10_2okpam1mfFfGjH548e4NbY5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello, next to your linux command you can get output like ; pg_restore -
... - ... * 2>&1 | ts '[%Y-%m-%d %H:%M:%S]' > pg_restore_output.log*

Murthy Nunna <mnunna(at)fnal(dot)gov>, 20 Ara 2023 Çar, 02:08 tarihinde şunu yazdı:

> Hi,
>
>
>
> I am running pg_restore on a large (~20TB) database. I am using -V flag.
> Is there a way I can get timestamps in front of each line that is logged in
> the output.
>
>
>
> pg_restore: launching item 5470 INDEX ….
>
> pg_restore: creating INDEX ….
>
> pg_restore: finished item 6131 TABLE DATA …
>
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar 2023-12-20 09:05:52 Truncate data from whole cluster
Previous Message bimal maity 2023-12-20 03:35:03 Oracle to Postgres migration