From PostgreSQL wiki
Current source may be checked out from:
Note that the current version doesn't `make` correctly if more than one database is installed on your system. Patches welcome. :)
The OSDL-DBT-2 test kit was originally ported to work with PostgreSQL 7.3. This doc is being updated for the 8.4beta2 version of Pg. Current source code for PostgreSQL can be downloaded from http://www.postgresql.org
Before running the configure script for PostgreSQL, alter src/include/pg_config_manual.h so that INDEX_MAX_KEYS = 64.
For a standard install:
./configure --prefix=<installation dir> make make install
Check ./configure --help and the PostgreSQL documentation for other configuration options.
DO NOT run initdb or start the postmaster at this point. Our script will create the database and start the database engine for you.
Installing the DBT-2 Test Kit
The latest stable version of the kit can be found on PostgreSQL's git repo at:
Follow the instructions in INSTALL. Check the README(s) included with the source for information specific to your environment.
Things to check if you are having problems building:
- is pg_config in your path? (e.g. /usr/local/pgsql/bin)