Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XUSvD-0000kD-Ju for pgsql-admin@arkaria.postgresql.org; Thu, 18 Sep 2014 04:02:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XUSvD-00018k-3b for pgsql-admin@arkaria.postgresql.org; Thu, 18 Sep 2014 04:02:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XUSvA-00018X-TO for pgsql-admin@postgresql.org; Thu, 18 Sep 2014 04:02:16 +0000 Received: from [203.122.16.200] (helo=zimbrab.pinelabs.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XUSuz-0003lf-NA for pgsql-admin@postgresql.org; Thu, 18 Sep 2014 04:02:15 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by zimbrab.pinelabs.com (Postfix) with ESMTP id 2C6733C829F3 for ; Thu, 18 Sep 2014 09:32:01 +0530 (IST) X-Amavis-Modified: Mail body modified (using disclaimer) - zimbrab.pinelabs.com X-Virus-Scanned: amavisd-new at pinelabs.com Received: from zimbrab.pinelabs.com ([127.0.0.1]) by localhost (zimbrab.pinelabs.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id hm88QLTxjRZO for ; Thu, 18 Sep 2014 09:31:52 +0530 (IST) Received: from pinenoil10585 (pinenoil10585.pinelabs.com [192.168.101.196]) by zimbrab.pinelabs.com (Postfix) with ESMTPSA id 847E83C82B34 for ; Thu, 18 Sep 2014 09:31:52 +0530 (IST) Reply-To: From: "Rajiv Kasera" To: Subject: Archiving & Reporting Support in PG9.3 Date: Thu, 18 Sep 2014 09:31:51 +0530 Organization: Pine Labs Message-ID: <024901cfd2f5$47812460$d6836d20$@pinelabs.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_024A_01CFD323.613B0E10" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac/S9IAdbRRxeNGkR5+YoM5GChTLOg== Content-Language: en-us X-Host-Lookup-Failed: Reverse DNS lookup failed for 203.122.16.200 (failed) X-Pg-Spam-Score: 1.6 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_024A_01CFD323.613B0E10 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, We are using Postgresql 9.3 for HTTP API server and pushing all HTTP request information in a log table. We want to archive the log table on a daily basis and run some reporting jobs to capture metrics for our APIs. There are some other reporting requirements where we will insert summary information in certain tables on a daily basis. Is there any tool which can ease this implementation or any good approach for this problem? Any help regarding the same would be highly appreciated. Thanks and Regards, Rajiv This message may contain privileged and confidential information and is solely for the use of intended recipient. The views expressed in this email are those of the sender and not of Pine Labs. The recipient should check this email and attachments for the presence of viruses / malwares etc. Pine Labs accepts no liability for any damage caused by any virus transmitted by this email. Pine Labs may monitor and record all emails. ------=_NextPart_000_024A_01CFD323.613B0E10 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

We are using = Postgresql 9.3 for HTTP API server and pushing all HTTP request = information in a log table. We want to archive the log table on a daily = basis and run some reporting jobs to capture metrics for our APIs. There = are some other reporting requirements where we will insert summary = information in certain tables on a daily basis.

 

Is there any = tool which can ease this implementation or any good approach for this = problem? Any help regarding the same would be highly = appreciated.

 

Thanks and Regards,
Rajiv

 

 


=
This message may contain privileged and confidential information and is solely for the use of intended recipient. The views expressed in this email are those of the sender and not of Pine Labs. The recipient should check this email and attachments for the presence of viruses / malwares etc. Pine Labs accepts no liability for any damage caused by any virus transmitted by this email. Pine Labs may monitor and record all emails.
=0A
= ------=_NextPart_000_024A_01CFD323.613B0E10--