]> git.evergreen-ils.org Git - Evergreen.git/commit
bug #680096 - upgrade script to partially reingest bibs after upgrade to 2.0
authorgmc <gmc@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 22 Nov 2010 17:17:59 +0000 (17:17 +0000)
committergmc <gmc@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 22 Nov 2010 17:17:59 +0000 (17:17 +0000)
commit33a6aa2099b93c5475f8f1262e74fb508c14a4b1
treee56a7cad68014c86cfe384e601b75b94f62c64ad
parent52c0cc42d8066db1e0e5f6f293e143411aec8cbe
bug #680096 - upgrade script to partially reingest bibs after upgrade to 2.0

This solves the problem of the new facets sidebar showing up empty in
OPAC search results.  Since the process of populating metabib.facet_entry
and updating metabib.*_field_entry can take a long time on large databases,
the update SQL is generated by a separate script, reingest-1.6-2.0.pl.  Usage
from an example run is:

./reingest-1.6-2.0.pl: generate SQL script to reingest bibs during an upgrade to Evergreen 2.0

By default, the script writes to the file reingest-1.6-2.0.sql.  To modify
this script's behavior, you can supply the following options:

--config /path/to/opensrf_core.xml  used to get connection information to
                                    the Evergreen database
--chunk_size n                      number of bibs to reingest in a chunk;
                                    specify if you don't want all of the
                                    bibs in the database to be reindexes
                                    in a single transaction
--output /path/to/output_file.sql   path of output SQL file

Writing output to file reingest-1.6-2.0.sql

SQL script complete.  To perform the reingest, please run the script using
the psql program, e.g.,

psql {connection parameters}  < reingest-1.6-2.0.sql

If you are running a large Evergreen installation, it is recommend that you
examine the script first; note that a reingest of a large Evergreen database
can take several hours.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@18826 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql
Open-ILS/src/sql/Pg/reingest-1.6-2.0.pl [new file with mode: 0755]