[rtg] rated update
Matt Provost
mprovost at termcap.net
Tue Nov 10 17:47:08 EST 2009
On Tue, Nov 10, 2009 at 11:14:22PM +0100, Harry Marcson wrote:
> Hi Matt,
>
> Looks good!
>
> I was wondering though, how much is the database structure changed? I would be
> glad to dump rtg 0.7.4 and go for rated, but our billing system is hooked up
> with the rtg database, and I don't want to take any risks in the billing part.
>
> I couldn't find any SQL file inside the rated archive.
>
The table structure is basically the same. The data tables have columns
with an iid, timestamp, counter and rate. There's a new table that maps
iids to oids instead of doing it in a config file.
It creates all of the tables as it needs them so there's no sql file to
run any more. The big difference is that it makes a table for each
device that it polls. So any systems that you've built will have to look
for new table names.
And all of this is for postgres only at the moment until the code is
ported to the mysql driver.
Thanks,
Matt
More information about the RTG
mailing list