| From: | Harry Broomhall <harry(dot)broomhall(at)uk(dot)easynet(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: continuous data from stdin |
| Date: | 2003-02-18 18:20:52 |
| Message-ID: | cbu45vsbah3k5lsga8ldmfhqcskc3af7gi@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 18 Feb 2003 18:09:45 +0000 (UTC),
Alexey(dot)Veretennikov(at)comline(dot)uu(dot)ru ("???????????? ???????") wrote:
>Hello, everybody!
>
>I think it's a common question, though I couldn't find any information aboo=
>ut it so far. I've got a program that puts its logs into stdout. What is th=
>e best solution to insert these logs into a table as they occur?
>
It rather depends on the volume of these logs, but a reasonable
first pass, if the volume isn't too big, would be to write a Perl prog
to listen on stdin and write to the database.
If it was me I'd use tee as part of the pipe so I could have an
alternative record if something didn't work.
Regards,
Harry.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Boes | 2003-02-18 18:34:30 | Re: continuous data from stdin |
| Previous Message | Aurangzeb M. Agha | 2003-02-18 18:16:20 | changing the last_value in a sequence |