Book Image

PostgreSQL Replication, Second Edition

Book Image

PostgreSQL Replication, Second Edition

Overview of this book

Table of Contents (22 chapters)
PostgreSQL Replication Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Installing pgpool


Just as we have seen for PostgreSQL, PgBouncer and most other tools covered in this book, we can either install pgpool from source or just use a binary. Again, we will describe how the code can be compiled from source.

To install pgpool, we have to download it first from the following path:

http://www.pgpool.net/download.php?f=pgpool-II-3.4.2.tar.gz.

Once this has been done, we can extract the tarball:

$ tar xvfz pgpool-II-3.4.2.tar.gz

The installation procedure is just like we have seen already. The first thing we have to call is configure along with some parameters. In our case, the main parameter is --with-pgsql, which tells the build process where to find our PostgreSQL installation.

$ ./configure --with-pgsql=/usr/local/pgsql/

Of course, there are some additional settings:

  • --with-openssl builds pgpool with OpenSSL support thus allowing encrypted connections

  • --enable-table-lock and --enable-sequence-lock are needed for compatibility with very old versions of pgpool

  • -...