How to install Bioseg into Postgres

In addition to bioseg, we need the standard postgresql contrib software, so install that. (On debian, apt-get install postgresql-contrib-8.4, on fedora, yum install postgresql-contrib).

To compile the bioseg code, we need the postgres header files, so install that too. (On debian, apt-get install postgresql-server-dev-8.4, on fedora, yum install postgresql-devel).

Download the bioseg tar from  http://www.bioinformatics.org/bioseg/wiki/. We are currently using version 0.8, which has a major bugfix and performance improvement over version 0.6.

Untar the file, and change to the created directory.

Type:

make USE_PGXS=t clean
make USE_PGXS=t
make USE_PGXS=t install

Now, you need to create the bioseg type in each database that is going to use it. If you create it in the template1, then all newly-created databases will have the bioseg type. We also need to create the default gist operators too, in order to have normal types in multi-column indexes.

Change directory to the postgres contrib directory (on Debian, /usr/share/postgresql/8.4/contrib, on fedora, /usr/share/pgsql/contrib), and for each database, type:

psql (database) <bioseg.sql
psql (database) <btree_gist.sql

However, do not install bioseg to the template0 or postgres databases - they should never be altered.