Re: Error when upgrading 1.2 db to 1.3 db

[Nigel Titley <..hidden..>]

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?)

Nigel