> > 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 pipe at all. I tried several things like writing to log file from the script or send the output of the script to STDOUT and redirecting from there but no matter what I did if I sent the output of the pg_standby to the pipe the script received nothing and all the output went to postgres log file. The last thing I tried looked like this. restore_command = '/usr/lib/postgresql/8.3/bin/pg_standby -l -d -s 30 -t /var/lib/postgresql/pgsql.trigger /var/lib/postgresql/archive %f %p %r 2 | /var/lib/postgresql/prepend_timestamp.sh >> /var/lib/postgresql/standby.log' As I said I tried several things like not redirecting to a file, redirecting in the script etc. I guess the next thing to try is to tail the log file and create a new log file with the timestamps. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
