Upgrading from 0.9.3 to 1.1.3 or 1.1.6

[Nico -telmich- Schottelius]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070720/10b66c61/attachment.pgp>