On 2020-11-20 19:01:47 +0100, Durumdara wrote: > 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 You can pipe the output through a timestamping tool like this: pg_dump --compress=5 -v -Fd -f "$name.$$" $db 2>&1 | ts > log/"$name".$(isodate).log ts is available here: https://github.com/hjp/simple/tree/master/ts hp -- _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@xxxxxx | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!"
Attachment:
signature.asc
Description: PGP signature
