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

Re: Error when upgrading 1.2 db to 1.3 db



On Sat, Dec 31, 2011 at 12:44 AM, Nigel Titley <..hidden..> 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;
>               ^

The above are all normal pre-9.1 but run in separate transactions so
it doesn't matter.

> 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

Ok now we are getting somewhere.

What username are you using to set up the database?  It must be a
database superuser.

Best Wishes,
Chris Travers

>
> I'll have a poke around into the permissions of the postgres user (this
> is running as postgres isn't it?)
>
> Nigel
>
> ------------------------------------------------------------------------------
> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
> infrastructure or vast IT resources to deliver seamless, secure access to
> virtual desktops. With this all-in-one solution, easily deploy virtual
> desktops for less than the cost of PCs and save 60% on VDI infrastructure
> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel