Home > mailing lists

best practice in archiving CDR data - Mailing list pgsql-general

From	Juan Backson
Subject	best practice in archiving CDR data
Date	March 29, 2010 13:27:51
Msg-id	27c25bc41003290627s56247d3et3d9ccd8a0d890d31@mail.gmail.com Whole thread Raw
Responses	Re: best practice in archiving CDR data ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List	pgsql-general

Hi,

I am using Postgres to store CDR data for voip switches. The data size quickly goes about a few TBs.

What I would like to do is to be able to regularly archive the oldest data so only the most recent 6 months of data is available.

All those old data will be stored in a format that can be retrieved back either into DB table or flat files.

Does anyone know how should I go about doing that? Is there any existing tool that can already do that?

thanks,

From: Pavel Stehule
Date: 29 March 2010, 12:43:14
Subject: Re: Splitting text column to multiple rows

From: "A. Kretschmer"
Date: 29 March 2010, 13:33:48
Subject: Re: best practice in archiving CDR data