My TPCx-V User's Guide Appendix

In CentOS forgot to install the 2.2 steps, so I run

yum group install "Server with GUI" "Large Systems Performance" "Performance Tools" "Compatibility Libraries" "Development Tools" "File and Storage Server" "Guest Agents " "Network File System Client"

Java Installation

cd /opt/
wget --no-cookies --no-check-certificate --header "Cookie: gpw_e24=http%3A%2F%2Fwww.oracle.com%2F; oraclelicense=accept-securebackup-cookie" "http://download.oracle.com/otn-pub/java/jdk/7u79-b15/jdk-7u79-linux-x64.tar.gz"
tar xzf jdk-7u79-linux-x64.tar.gz

cd /opt/jdk1.7.0_79/

alternatives --install /usr/bin/java java /opt/jdk1.7.0_79/bin/java 2
alternatives --config java

alternatives --install /usr/bin/jar jar /opt/jdk1.7.0_79/bin/jar 2
alternatives --set jar /opt/jdk1.7.0_79/bin/jar
alternatives --install /usr/bin/javac javac /opt/jdk1.7.0_79/bin/javac 2
alternatives --set javac /opt/jdk1.7.0_79/bin/javac
alternatives --install /usr/bin/javah javah /opt/jdk1.7.0_79/bin/javah 2
alternatives --set javah /opt/jdk1.7.0_79/bin/javah
alternatives --install /usr/bin/rmic rmic /opt/jdk1.7.0_79/bin/rmic 2
alternatives --set rmic /opt/jdk1.7.0_79/bin/rmic

ODBC

wget ftp://195.220.108.108/linux/centos/7.2.1511/os/x86_64/Packages/unixODBC-devel-2.3.1-11.el7.x86_64.rpm
wget ftp://195.220.108.108/linux/centos/7.2.1511/os/x86_64/Packages/unixODBC-2.3.1-11.el7.x86_64.rpm
yum install unixODBC-2.3.1-10.el7.x86_64.rpm unixODBC-devel-2.3.1-10.el7.x86_64.rpm

wget https://yum.postgresql.org/9.3/redhat/rhel-7-x86_64/postgresql93-odbc-09.03.0400-1PGDG.rhel7.x86_64.rpm

# The downloaded package above was not installed since the newer was installed in its place by the command below

yum install postgresql93 postgresql93-libs postgresql93-devel postgresql93-server postgresql93-odbc

Postgres

When setuping the postgres profile remember to change the JAVA_INC to the correct /opt dir

export JAVA_INC=/usr/java/latest/include

Version of pgstatspack:

wget http://pgfoundry.org/frs/download.php/3151/pgstatspack_version_2.3.1.tar.gz

Setup ssh without pass

Accordingly with the documentation "The run-time bash scripts depend on the prime driver being able to ssh into all 13 VMs, as both root and postgres, using the file .ssh/authorized_keys. It's a good idea to set this up on the first VM before making the clones". So we performed :

As postgres:

ssh-keygen -t rsa
ssh-copy-id postgres@localhost
0ssh-copy-id root@localhost

As root:

ssh-keygen -t rsa
ssh-copy-id postgres@localhost
ssh-copy-id root@localhost
restorecon -R -v /var/lib/pgsql/.ssh/
restorecon -R -v /root/.ssh