[OPEN-ILS-DEV] ***SPAM*** RE: ***SPAM*** RE: ***SPAM*** Re: ***SPAM*** New Server/Upgrade from 1.4 to 1.6

[Adam Ray]

OK so I have the new server up and have everything installed and I've come to the DB migration part.

Here's what I've tried:

Old$ pg_dump evergreen > evergreen.sql

New$ createdb -E UNICODE evergreen
New$ createlang plperl evergreen
New$ createlang plperlu evergreen
New$ createlang plpgsql evergreen
New$ createuser -P -s evergreen
New$ psql -d evergreen < evergreen.sql

When it gets to the line:

CREATE FUNCTION gtsq_in(cstring) RETURNS gtsq
    AS '$libdir/tsearch2', 'gtsq_in'
    LANGUAGE c STRICT;

I get this error:

NOTICE:  return type gtsq is only a shell
ERROR:  could not find function "gtsq_in" in file "/usr/lib/postgresql/8.3/lib/tsearch2.so"

Am I taking the wrong approach?

Thanks,
Adam



________________________________________
From: open-ils-dev-bounces at list.georgialibraries.org [open-ils-dev-bounces at list.georgialibraries.org] on behalf of Galen Charlton [gmc at esilibrary.com]
Sent: Thursday, May 13, 2010 2:41 PM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] ***SPAM*** RE: ***SPAM*** Re: ***SPAM***    New     Server/Upgrade from     1.4     to 1.6

Hi,

On May 13, 2010, at 3:25 PM, Adam Ray wrote:
> One of the biggest problems we are having with the old installation is we have records we can look up by TCN, but won't show up in searches either in the staff client or OPAC.

Trying the procedure to reingest (i.e., reindex) bib records may help with that:

http://evergreen-ils.org/dokuwiki/doku.php?id=scratchpad:random_magic_spells#reingesting_bib_records

> Regarding the DB upgrade scripts, where would I find the procedures for that?

http://evergreen-ils.org/dokuwiki/doku.php?id=upgrading:evergreen:1.4_to_1.6

Regards,

Galen
--
Galen Charlton
VP, Data Services
Equinox Software, Inc. / Your Library's Guide to Open Source
email:  gmc at esilibrary.com
direct: +1 352-215-7548
skype:  gmcharlt
web:    http://www.esilibrary.com/