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,idle,2011-11-

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

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 , What we

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 enabled the csvlog option

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 am in a project that uses PostGresSql

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. -

[GENERAL] application for postgres Log

2012-09-10 Thread Arvind Singh
Hello and namaste 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 related

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

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 related

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