Archiving & Reporting Support in PG9.3

From: "Rajiv Kasera" <rajiv(dot)kasera(at)pinelabs(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Archiving & Reporting Support in PG9.3
Date: 2014-09-18 04:01:51
Message-ID: 024901cfd2f5$47812460$d6836d20$@pinelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2014-09-18 09:01:19 Re: Standby is not removing restored WAL segments
Previous Message Peter Eisentraut 2014-09-17 20:40:44 Re: How to interpret view pg_stat_bgwriter