Re: Error when upgrading 1.2 db to 1.3 db

[Nigel Titley <..hidden..>]

On 31/12/11 08:44, Nigel Titley wrote:
> On 31/12/11 02:20, Chris Travers wrote:
>> Check the /tmp/ledgersmb/dblog_stderr for the error.
> 
> psql:sql/Pg-database.sql:2: ERROR:  syntax error at or near "EXTENSION"
> LINE 1: CREATE EXTENSION tablefunc;
>                ^
> psql:sql/Pg-database.sql:3: ERROR:  syntax error at or near "EXTENSION"
> LINE 1: CREATE EXTENSION pg_trgm;
>                ^
> psql:sql/Pg-database.sql:4: ERROR:  syntax error at or near "EXTENSION"
> LINE 1: CREATE EXTENSION btree_gist;
>                ^
> probably related to this further down
> 
> psql:/usr/share/postgresql/8.4/contrib/tsearch2.sql:18: ERROR:
> permission denied for language internal
> psql:/usr/share/postgresql/8.4/contrib/tsearch2.sql:24: ERROR:
> permission denied for language c
> 
> I'll have a poke around into the permissions of the postgres user (this
> is running as postgres isn't it?)

Can't find anything obvious but I'm a postgres neophyte (MySQL is my
thing). Can anyone offer a pointer?

Nigel