Archiving & Reporting Support in PG9.3 - Mailing list pgsql-admin

From Rajiv Kasera
Subject Archiving & Reporting Support in PG9.3
Date
Msg-id 024901cfd2f5$47812460$d6836d20$@pinelabs.com
Whole thread Raw
List 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.

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: How to interpret view pg_stat_bgwriter
Next
From: Guillaume Lelarge
Date:
Subject: Re: Standby is not removing restored WAL segments