[OPEN-ILS-DEV] Debian install instructions: plpgsql barf

2008-02-05 Thread John Fink
Hey folks,

Following along (and editing some of) the Dokuwki instructions at
http://open-ils.org/dokuwiki/doku.php?id=installing_evergreen_1.2_on_debian_etch_x86_32-bit,
I get the following errors when doing a make install for
Evergreen-ILS-1.2.1.2.  I've installed the Debian etch
postgresql-plperl-8.1package, but something else is probably missing
as I'm doing this install on
as minimal a Debian machine as possible; basically nothing extra except
openssh-server.


jf


BEGIN
psql:000.english.pg81.fts-config.sql:9: ERROR:  language plpgsql does not
 exist
HINT:  Use CREATE LANGUAGE to load the language into the database.
psql:000.english.pg81.fts-config.sql:11: ERROR:  current transaction is abo
rted, commands ignored until end of transaction block
psql:000.english.pg81.fts-config.sql:12: ERROR:  current transaction is abo
rted, commands ignored until end of transaction block
psql:000.english.pg81.fts-config.sql:13: ERROR:  current transaction is abo
rted, commands ignored until end of transaction block
psql:000.english.pg81.fts-config.sql:14: ERROR:  current transaction is abo
rted, commands ignored until end of transaction block
(and so on so on ad infinitum, a bunch of aborts basically)

-- 
http://libgrunt.blogspot.com -- library culture and technology.


Re: [OPEN-ILS-DEV] Debian install instructions: plpgsql barf

2008-02-05 Thread Dan Scott
Hmm - this is undoubtedly my fault.

Will fix (by adding the plgpsql language instruction).

Thanks for the report, John!

Dan

On 05/02/2008, John Fink [EMAIL PROTECTED] wrote:
 Hey folks,

 Following along (and editing some of) the Dokuwki instructions at
 http://open-ils.org/dokuwiki/doku.php?id=installing_evergreen_1.2_on_debian_etch_x86_32-bit,
 I get the following errors when doing a make install for
 Evergreen-ILS-1.2.1.2.  I've installed the Debian etch postgresql-plperl-8.1
 package, but something else is probably missing as I'm doing this install on
 as minimal a Debian machine as possible; basically nothing extra except
 openssh-server.


 jf


 BEGIN
 psql:000.english.pg81.fts-config.sql:9: ERROR:  language plpgsql does not
  exist
 HINT:  Use CREATE LANGUAGE to load the language into the database.
 psql:000.english.pg81.fts-config.sql:11: ERROR:  current transaction is abo
  rted, commands ignored until end of transaction block
 psql:000.english.pg81.fts-config.sql:12: ERROR:  current transaction is abo
 rted, commands ignored until end of transaction block
 psql:000.english.pg81.fts-config.sql:13: ERROR:  current transaction is abo
  rted, commands ignored until end of transaction block
 psql:000.english.pg81.fts-config.sql:14: ERROR:  current transaction is abo
 rted, commands ignored until end of transaction block
 (and so on so on ad infinitum, a bunch of aborts basically)

 --
 http://libgrunt.blogspot.com -- library culture and technology.


-- 
Dan Scott
Laurentian University


Re: [OPEN-ILS-DEV] Debian install instructions: plpgsql barf

2008-02-05 Thread Bill Erickson
John Fink wrote:
 Hey folks,
 
 Following along (and editing some of) the Dokuwki instructions at
 http://open-ils.org/dokuwiki/doku.php?id=installing_evergreen_1.2_on_debian_etch_x86_32-bit,
 I get the following errors when doing a make install for
 Evergreen-ILS-1.2.1.2.  I've installed the Debian etch
 postgresql-plperl-8.1 package, but something else is probably missing as
 I'm doing this install on as minimal a Debian machine as possible;
 basically nothing extra except openssh-server.
 
 
 jf
 
 
 BEGIN
 psql:000.english.pg81.fts-config.sql:9: ERROR:  language plpgsql does not
  exist
 HINT:  Use CREATE LANGUAGE to load the language into the database.
 psql:000.english.pg81.fts-config.sql:11: ERROR:  current transaction is abo
 rted, commands ignored until end of transaction block
 psql:000.english.pg81.fts-config.sql:12: ERROR:  current transaction is abo
 rted, commands ignored until end of transaction block
 psql:000.english.pg81.fts-config.sql:13: ERROR:  current transaction is abo
 rted, commands ignored until end of transaction block
 psql:000.english.pg81.fts-config.sql:14: ERROR:  current transaction is abo
 rted, commands ignored until end of transaction block
 (and so on so on ad infinitum, a bunch of aborts basically)


I think those docs might need an additional:

su -c createlang plpgsql evergreen - postgres

-bill


-- 
Bill Erickson
| VP, Software Development  Integration
| Equinox Software, Inc. / The Evergreen Experts
| phone: 877-OPEN-ILS (673-6457)
| email: [EMAIL PROTECTED]
| web: http://esilibrary.com