Re: [GENERAL] timestams in the the pg_standby output

2010-01-05 Thread Greg Smith
Tim Uckun wrote: I guess the next thing to try is to tail the log file and create a new log file with the timestamps. See, told you it was harder than it looked :) I knew there was a gotcha here in the seemingly easy way to approach this but just couldn't remember the details of why it fel

Re: [GENERAL] timestams in the the pg_standby output

2010-01-05 Thread Tim Uckun
> > If that works, great.  I'm not sure if you'll run afoul of output buffering > in this situation.  Clearly you've got the right idea, just need to make > sure it behaves as you expect and doesn't clump the line reads into larger > chunks. Actually I could not get it to send the output to the pi

Re: [GENERAL] timestams in the the pg_standby output

2010-01-04 Thread Greg Smith
Tim Uckun wrote: 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 If that works, great. I'm not sure if you'll run afoul of output buffering in this situation. Clearly you've got th

Re: [GENERAL] timestams in the the pg_standby output

2010-01-04 Thread Tim Uckun
>     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 whil

Re: [GENERAL] timestams in the the pg_standby output

2010-01-04 Thread Greg Smith
Tim Uckun wrote: Is there a way to get pg_standby to put timestamps in the output it generates? I am currently piping the output to a log fie but since it contains no timestamps it's of limited use to me. Nope; already on my TODO list to take care of one day since it annoys me too. What yo

Re: [GENERAL] timestams in the the pg_standby output

2010-01-04 Thread Fujii Masao
On Tue, Jan 5, 2010 at 11:20 AM, Tim Uckun wrote: > Is there a way to get pg_standby to put timestamps in the output it > generates? No. > I am currently piping the output to a log fie but since it > contains no timestamps it's of limited use to me. You can create the script which adds the time