[SL] Upgrade problem

[Robert I. <ri...@ra...>]

Hi

Upgraded to 2.4 from 2.2.5. Have similar problem to others, but can't 
find a fix that works.

On first load of the upgrade, it looks to upgrade the db and I get the 
error:

Error!
...............
return NULL;
end;
' language 'plpgsql';

ERROR: language "plpgsql" does not exist

On entering:   psql template1 -U postgres -l

I get
          List of databases
    Name    |   Owner    | Encoding
-----------+------------+-----------
  Standard  | sql-ledger | SQL_ASCII
  template0 | postgres   | SQL_ASCII
  template1 | postgres   | SQL_ASCII
  test      | sql-ledger | SQL_ASCII
(4 rows)

but trying to run any of the following results in:

root@barnum sql-ledger # createlang plpgsql test
createlang: could not connect to database test: FATAL:  user "root" does 
not exist
root@barnum sql-ledger # createlang plpgsql Standard
createlang: could not connect to database Standard: FATAL:  user "root" 
does not exist
root@barnum sql-ledger # createlang plpgsql template1
createlang: could not connect to database template1: FATAL:  user "root" 
does not exist
root@barnum sql-ledger # createlang plpgsql template1
createlang: could not connect to database template1: FATAL:  user "root" 
does not exist

So I tried:

root@barnum sql-ledger # dropuser sql-ledger
dropuser: could not connect to database template1: FATAL:  user "root" 
does not exist

I am loathe to try "dropdb" as this will presumably remove all previous 
data?

Appreciate any help

Robert