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:13 +0000 (17:17 +0000)
committergmc <gmc@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 22 Nov 2010 17:17:13 +0000 (17:17 +0000)
commit8779e974f54f90e4aacbc4d11660349c059397b7
treea0697119a19203730db3f7337a40e17383fa0061
parent50948ad4e4863c9fdcaf37a519b1c8073832d9bc
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/branches/rel_2_0@18825 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]