Re: Error when upgrading 1.2 db to 1.3 db

[Nigel Titley <..hidden..>]

On 30/12/11 23:36, Nigel Titley wrote:
> On 30/12/11 23:03, ..hidden.. wrote:
>> Hi nigel,
>>
>> this is a known issue: your server doesn't have the postgresql contribs or they didn't get imported in your db. If you use setup.pl, be sure the path in ledgersmb.conf points to the right dir (9.0 or below).
> 
> I have postgresql contribs (installed in
> /usr/share/postgresql/8.4/contrib) and I put this path into the Contrib
> Dir box. I've tried both with and without the trailing '/'. It is
> correctly set in the ledgersmb.conf file as well.

Just for further information

nigel@loki:/usr/share/postgresql/8.4/contrib$ ls -l
total 472
-rw-r--r-- 1 root root  1548 2011-10-07 13:25 adminpack.sql
-rw-r--r-- 1 root root   273 2011-10-07 13:25 autoinc.sql
-rw-r--r-- 1 root root 25707 2011-10-07 13:25 btree_gin.sql
-rw-r--r-- 1 root root 31627 2011-10-07 13:25 btree_gist.sql
-rw-r--r-- 1 root root  1242 2011-10-07 13:25 chkpass.sql
-rw-r--r-- 1 root root 12720 2011-10-07 13:25 citext.sql
-rw-r--r-- 1 root root  8130 2011-10-07 13:25 cube.sql
-rw-r--r-- 1 root root  5568 2011-10-07 13:25 dblink.sql
-rw-r--r-- 1 root root   745 2011-10-07 13:25 dict_int.sql
-rw-r--r-- 1 root root   729 2011-10-07 13:25 dict_xsyn.sql
-rw-r--r-- 1 root root  3300 2011-10-07 13:25 earthdistance.sql
-rw-r--r-- 1 root root  1267 2011-10-07 13:25 fuzzystrmatch.sql
-rw-r--r-- 1 root root  6647 2011-10-07 13:25 hstore.sql
-rw-r--r-- 1 root root   297 2011-10-07 13:25 insert_username.sql
-rw-r--r-- 1 root root  1086 2011-10-07 13:25 int_aggregate.sql
-rw-r--r-- 1 root root 10746 2011-10-07 13:25 _int.sql
-rw-r--r-- 1 root root 68829 2011-10-07 13:25 isn.sql
-rw-r--r-- 1 root root   742 2011-10-07 13:25 lo.sql
-rw-r--r-- 1 root root 18944 2011-10-07 13:25 ltree.sql
-rw-r--r-- 1 root root   283 2011-10-07 13:25 moddatetime.sql
-rw-r--r-- 1 root root  2464 2011-10-07 13:25 pageinspect.sql
-rw-r--r-- 1 root root   779 2011-10-07 13:25 pg_buffercache.sql
-rw-r--r-- 1 root root  5222 2011-10-07 13:25 pgcrypto.sql
-rw-r--r-- 1 root root   902 2011-10-07 13:25 pg_freespacemap.sql
-rw-r--r-- 1 root root   556 2011-10-07 13:25 pgrowlocks.sql
-rw-r--r-- 1 root root   847 2011-10-07 13:25 pg_stat_statements.sql
-rw-r--r-- 1 root root  1974 2011-10-07 13:25 pgstattuple.sql
-rw-r--r-- 1 root root  3809 2011-10-07 13:25 pg_trgm.sql
-rw-r--r-- 1 root root  2135 2011-10-07 13:25 pgxml.sql
-rw-r--r-- 1 root root   375 2011-10-07 13:25 refint.sql
-rw-r--r-- 1 root root  7950 2011-10-07 13:25 seg.sql
-rw-r--r-- 1 root root  1045 2011-10-07 13:25 sslinfo.sql
-rw-r--r-- 1 root root  2306 2011-10-07 13:25 tablefunc.sql
-rw-r--r-- 1 root root   881 2011-10-07 13:25 test_parser.sql
-rw-r--r-- 1 root root   542 2011-10-07 13:25 timetravel.sql
-rw-r--r-- 1 root root 15845 2011-10-07 13:25 tsearch2.sql
-rw-r--r-- 1 root root   528 2011-10-07 13:25 uninstall_adminpack.sql
-rw-r--r-- 1 root root  6137 2011-10-07 13:25 uninstall_btree_gin.sql
-rw-r--r-- 1 root root  7730 2011-10-07 13:25 uninstall_btree_gist.sql
-rw-r--r-- 1 root root   387 2011-10-07 13:25 uninstall_chkpass.sql
-rw-r--r-- 1 root root  2858 2011-10-07 13:25 uninstall_citext.sql
-rw-r--r-- 1 root root  1999 2011-10-07 13:25 uninstall_cube.sql
-rw-r--r-- 1 root root  1905 2011-10-07 13:25 uninstall_dblink.sql
-rw-r--r-- 1 root root   389 2011-10-07 13:25 uninstall_dict_int.sql
-rw-r--r-- 1 root root   379 2011-10-07 13:25 uninstall_dict_xsyn.sql
-rw-r--r-- 1 root root   593 2011-10-07 13:25 uninstall_earthdistance.sql
-rw-r--r-- 1 root root   507 2011-10-07 13:25 uninstall_fuzzystrmatch.sql
-rw-r--r-- 1 root root  1803 2011-10-07 13:25 uninstall_hstore.sql
-rw-r--r-- 1 root root   373 2011-10-07 13:25 uninstall_int_aggregate.sql
-rw-r--r-- 1 root root  2834 2011-10-07 13:25 uninstall__int.sql
-rw-r--r-- 1 root root   700 2011-10-07 13:25 uninstall_isn.sql
-rw-r--r-- 1 root root   469 2011-10-07 13:25 uninstall_lo.sql
-rw-r--r-- 1 root root  5041 2011-10-07 13:25 uninstall_ltree.sql
-rw-r--r-- 1 root root   510 2011-10-07 13:25 uninstall_pageinspect.sql
-rw-r--r-- 1 root root   275 2011-10-07 13:25 uninstall_pg_buffercache.sql
-rw-r--r-- 1 root root  1696 2011-10-07 13:25 uninstall_pgcrypto.sql
-rw-r--r-- 1 root root   292 2011-10-07 13:25 uninstall_pg_freespacemap.sql
-rw-r--r-- 1 root root   234 2011-10-07 13:25 uninstall_pgrowlocks.sql
-rw-r--r-- 1 root root   322 2011-10-07 13:25
uninstall_pg_stat_statements.sql
-rw-r--r-- 1 root root   335 2011-10-07 13:25 uninstall_pgstattuple.sql
-rw-r--r-- 1 root root  1078 2011-10-07 13:25 uninstall_pg_trgm.sql
-rw-r--r-- 1 root root   832 2011-10-07 13:25 uninstall_pgxml.sql
-rw-r--r-- 1 root root  1792 2011-10-07 13:25 uninstall_seg.sql
-rw-r--r-- 1 root root   442 2011-10-07 13:25 uninstall_sslinfo.sql
-rw-r--r-- 1 root root   770 2011-10-07 13:25 uninstall_tablefunc.sql
-rw-r--r-- 1 root root   430 2011-10-07 13:25 uninstall_test_parser.sql
-rw-r--r-- 1 root root  3627 2011-10-07 13:25 uninstall_tsearch2.sql
-rw-r--r-- 1 root root   566 2011-10-07 13:25 uninstall_uuid-ossp.sql
-rw-r--r-- 1 root root  1509 2011-10-07 13:25 uuid-ossp.sql
nigel@loki:/usr/share/postgresql/8.4/contrib$

Nigel