[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: users/members.LCK : Permission denied



> You're using a 7.x version of PostgreSQL.  It looks like the upgrade
> script only supports PostgreSQL 8.x.  A quick note on backporting the
> script Pg-upgrade-2.6.17-2.6.18.sql: change the 'ALTER TABLE foo
> ALTER COLUMN bar TYPE numeric' lines into a sequence of lines
> renaming the float column, adding a numeric column, updating its
> values, and dropping the float column.  You'll also have to remove
> users/nologin.

even the testing debian doesn't provide the 8.X version of Postgresql :(
there is a ton of ALTER COLUMN to do...

> I'll be on IRC later, if you want help.

#ledger-smb ?

thanks a lot

Philippe