Re: [GENERAL] application for postgres Log

2012-09-21 Thread Albe Laurenz
Arvind Singh wrote: > Our CSV Log contains lot of statements like the following THREE lines. They appear exactly one after > the other. > > And they number in thousands for a Session (more than ten thousand) > > > 2011-11-11 12:41:31.484 IST,"agent1","pem",524,"localhost:2141",4ebccaa2.20c,754,"

Re: [GENERAL] application for postgres Log

2012-09-20 Thread Arvind Singh
thanx Laurenz, But Our CSV Log contains lot of statements like the following THREE lines. They appear exactly one after the other. And they number in thousands for a Session (more than ten thousand) 2011-11-11 12:41:31.484 IST,"agent1","pem",524,"localhost:2141",4ebccaa2.20c,754,"idle"

Re: [GENERAL] application for postgres Log

2012-09-17 Thread Albe Laurenz
Arvind Singh wrote: > I have come across a very peculiar situation. > > We have a postgres installation 9.0. It was installed last year. > > But we started implementation on it, just recently. > > And therefore the need to develop a Logparser application. > > During our preliminary parsing , Wh

Re: [GENERAL] application for postgres Log

2012-09-15 Thread Arvind Singh
Frost, Stopping by Woods on a Snowy Evening) > Subject: RE: [GENERAL] application for postgres Log > Date: Fri, 14 Sep 2012 13:16:33 +0200 > From: laurenz.a...@wien.gv.at > To: arvin...@hotmail.com; pgsql-general@postgresql.org > > Arvind Singh wrote: > > I have e

Re: [GENERAL] application for postgres Log

2012-09-14 Thread Albe Laurenz
Arvind Singh wrote: > I have enabled the csvlog option. > > There seem to be 24 columns in the Log. I have difficulty in understanding the following columns > > - virtual_transaction_id Such a transaction ID is given to every transaction. Can be used to track transactions in the log. > - transa

Re: [GENERAL] application for postgres Log

2012-09-14 Thread Arvind Singh
log structure mentioned in documentation arvind > Subject: RE: [GENERAL] application for postgres Log > Date: Mon, 10 Sep 2012 09:31:29 +0200 > From: laurenz.a...@wien.gv.at > To: arvin...@hotmail.com; pgsql-general@postgresql.org > > Arvind Singh wrote: > > I a

Re: [GENERAL] application for postgres Log

2012-09-10 Thread Ireneusz Pluta
W dniu 2012-09-10 08:19, Arvind Singh pisze: I need some help or even a simple link that is related to this subject you might be interested in reading this: http://bucardo.org/wiki/Tail_n_mail -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subs

Re: [GENERAL] application for postgres Log

2012-09-10 Thread Albe Laurenz
Arvind Singh wrote: > I am in a project that uses PostGresSql v9.0. We are developing an application in CSharp to parse the > PG server activity log installed on Windows 2003/XP or higher. > > Our application will : > Scan the Log for a given search text and Post rows found > Produce statistics re

Re: [GENERAL] application for postgres Log

2012-09-10 Thread John R Pierce
On 09/09/12 11:19 PM, Arvind Singh wrote: I am in a project that uses PostGresSql v9.0. We are developing an application in CSharp to parse the PG server activity log installed on Windows 2003/XP or higher. Our application will : Scan the Log for a given search text and Post rows found Produce