Hello Peter, Peter Nixon [Fri, Jul 13, 2007 at 02:40:09PM +0300]:
Just a quick tip to get you started as I have to head out and may not have a chance to reply until tomorrow:
ALTER TABLE radacct ALTER acctinputoctets TYPE bigint;
and
ALTER TABLE radacct ADD XAscendSessionSvrKey VARCHAR(10);
Thank you! I am for safety now checking all values and recognized that the schema shipped with 1.1.6 for postgres seems to be broken: XAscendSessionSvrKey VARCHAR(10), <-----| FramedProtocol VARCHAR(32), | FramedIPAddress INET, | AcctStartDelay BIGINT, | duplicated! AcctStopDelay BIGINT, | XAscendSessionSvrKey VARCHAR(10) <-----| I'll post a update script as soon as I'm finished.
Just go though your schema line by line and compare with the one in doc/examples/postgresql.sql running either one of those 2 commands (with the correct datatype and column name) until your schema looks like the default one. You should not lose any data in the process, but its a good idea to have a backup of you table in any case.
yep, doing that. will tell you whether it worked or not (should) later. Nico -- Think about Free and Open Source Software (FOSS). http://nico.schottelius.org/documentations/foss/the-term-foss/ PGP: BFE4 C736 ABE5 406F 8F42 F7CF B8BE F92A 9885 188C