Install pgpool with vPostgres

vPostgres is another distribution of PostgreSQL from VMware. There is a little bit different to install pgpool with it. You are supposed to see error messages like “libpq is not installed or libpq is old” in the configuration phase or “error libpq-fe.h no such file or directory” in the make phase.

  1. To resolve libpq problem. You need copy vpostgres-ldconfig-x86_64.conf to /etc/ld.so.conf.d, and run ldconfig.
    cp /opt/vmware/vpostgres/current/share/libpq-doc/vpostgres-ldconfig-x86_64.conf /etc/ld.so.conf.d/
    ldconfig
  2. Then you can run the configure script in pgpool extracted source. As vPostgres was not installed to /usr/local by default. So you need put a switch behind the script.
    ./configure –with-pgsql=/opt/vmware/vpostgres/current/
  3. Before you run the make command, confirm you have server and client development package installed. If not, install it.
    rpm -ivh VMware-vFabric-Postgres-client-devel-9.2.4.0-1080137.x86_64.rpm VMware-vFabric-Postgres-server-devel-9.2.4.0-1080137.x86_64.rpm
  4. Now you can run make.
    make
  5. Now you can install.
    make install
  6. Before you run the pgpool, create a folder for its pid file
    mkdir /var/run/pgpool
  7. Then you need make a copy of pgpool.conf.
    cp /usr/local/etc/pgpool.conf.sample /usr/local/etc/pgpool.conf
  8. Use your preferred editor to change the configuration file.
Advertisements
Post a comment or leave a trackback: Trackback URL.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: