Re: timestams in the the pg_standby output - Mailing list pgsql-general

From Tim Uckun
Subject Re: timestams in the the pg_standby output
Date
Msg-id 855e4dcf1001042322w3cbca5fbnfead54b0ac0f480f@mail.gmail.com
Whole thread Raw
In response to Re: timestams in the the pg_standby output  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: timestams in the the pg_standby output  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
>     printf "%s %s\n", strftime("%Y-%m-%d %H:%M:%S", localtime(time)), $item
>
> (untested, and I am not a regular Perl programmer, its but File::Tail is the
> best library I know of to do this sort of thing)
>


Ah if I am going to do that I suppose something like this would work.

#!/bin/sh
while read data; do
    echo "`date +%H:%M:%S` : $data" >> logfile.log
done

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: timestams in the the pg_standby output
Next
From: Yan Cheng Cheok
Date:
Subject: Re: PostgreSQL Write Performance