[go: up one dir, main page]
Scribd
Upload
887 views2 pages

Pgpool2 Install in Debian Etch

This document provides instructions for installing pgpool-II, an open source connection pooler and replication server for PostgreSQL, on a Debian etch system. It describes downloading and extracting the pgpool-II source code, compiling and installing it, configuring the pgpool.conf and pcp.conf files, and installing required C language functions to enable online recovery of databases. Following these steps allows pgpool-II to transparently pool connections and replicate data between PostgreSQL servers.

Uploaded by

Ajay Kumar
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
887 views2 pages

Pgpool2 Install in Debian Etch

This document provides instructions for installing pgpool-II, an open source connection pooler and replication server for PostgreSQL, on a Debian etch system. It describes downloading and extracting the pgpool-II source code, compiling and installing it, configuring the pgpool.conf and pcp.conf files, and installing required C language functions to enable online recovery of databases. Following these steps allows pgpool-II to transparently pool connections and replicate data between PostgreSQL servers.

Uploaded by

Ajay Kumar
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

How to install Pgpool-II in Debian etch (4)

PGPOOL-II

Introduction

pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It
provides the following features.
1. Connection Pooling
2. Replication
3. Load Balance
4. Limiting Exceeding Connections
5. Parallel Query
pgpool-II talks PostgreSQL's backend and frontend protocol, and relays a connection between them. Therefore,
a database application (frontend) thinks that pgpool-II is the actual PostgreSQL server, and the server
(backend) sees pgpool-II as one of its clients. Because pgpool-II is transparent to both the server and the client,
an existing database application can be used with pgpool-II almost without a change to its sources.
Getting source
Pgpool-II source files can be down loaded from the following link.
http://pgfoundry.org/projects/pgpool/
Version 2.2.5 tar­ ball is to be downloaded to a temporary directory (Home)
Then extract the tar­ball (Right click on the file pgpool­II­2.2.5.tar.gz and 
select Extract here )
Prerequisit
Postgresql 8.1­deb package has to be installed in addition to the normal 
postgresql installation
Installation
In terminal login as root.
$ su
#cd pgpool­II­2.2.5
#./configure
#make
#make install

Binaries will be installed to /usr/local/bin

configuration file location /usr/local/etc

sample configuration files will be installed at the above location
This files are to be renamed as shown below.

pgpool.conf.sample ­­­­­>pgpool.conf

pcp.conf.sample ­­­­>pcp.conf

In the pgpool .conf file following changes are to be made

Unix domain socket changed from /tmp to /var/run/postgresql
log directory is to be changed to /var/run/pgpool
The directory /var/run/pgpool is to be created manually
change ownership of this folder to postgresql by issuing the following command in 
the root terminal.

chown postgres /var/run/pgpool
C Language function Installation

This is necessary to perform online recovery of the database.


In the root terminal
#cd pgpool­II­2.2.3/sql/pgpool­recovery
#make install

(A file named pgpool­recovery.sql will be generated by the above command)

#psql ­U postgres ­f pgpool­recovery.sql template1

pgpool­recovery.sql is a database dump file which will be restored to template1 
database
This will provide C language functionalities to all database created from 
template1

You might also like