Code Monkey home page Code Monkey logo

pgpool-ii-installer's Introduction

pgpool-II-installer

Version

1.0 beta1

Overview

This is the package of scripts to create pgpool-II's installer.
[NOTICE] You should get RPM packages of pgpool-II and pgpoolAdmin by yourself.

What the installer for pgpool can do:

  • Install pgpool-II and pgpoolAdmin into both of servers for pgpool-II and backend nodes for PostgreSQL by RPM.
  • Generate config files for pgpool-II, pgpoolAdmin and PostgreSQL.
  • master-slave mode with streaming replication / pgpool's native replication
  • watchdog
  • load balance
  • health check
  • on memory query cache
  • etc...
  • Generate the scripts for fail over and online recovery.
  • Setup SSH connections without inputting passwords.

How to make the installer

1. Get RPM packages of pgpool-II and pgpoolAdmin.

$ git clone https://github.com/sraoss/pgpool-II-installer
$ cd pgpool-II-installer
$ wget http://www.pgpool.net/download.php?f=pgpool-II-pg{pg_version}-{version}.pgdg.x86_64.rpm
$ wget http://www.pgpool.net/download.php?f=pgpoolAdmin-{version}.pgdg.noarch.rpm

These RPM packages can be downloaded from here.

2. Edit the config file for installer.

Edit lib/param.sh.

$ edit lib/param.sh

Parameters

parameter's name example category description
PG_MAJOR_VERSION 9.3 PostgreSQL major version
MAJOR_VERSION 3.3 pgpool-II major version
P_VERSION 3.3.3 pgpool-II full version
P_RELEASE 1 pgpool-II release number of RPM package
A_VERSION 3.3.1 pgpoolAdmin full version
A_RELEASE 1 pgpoolAdmin release number of package

How to use the installer

$ su -

# whoami
root
# cd /path/to/installer
# ./install.sh

After answering some questions, installation and setup will start.

(Advanced)

If you create the config file called "installer.conf" before you execute install.sh, install.sh uses the parameters in the file as the default value of questions by the script.

$ cp installer.conf.sample installer.conf
$ edit installer.conf

# whoami
root
# cd /path/to/installer
# ./install.sh

Parameters

parameter's name example category description
DEF_PGPOOL_WATCHDOG yes pgpool-II use watchdog
DEF_PGPOOL_HOST_ARR[0] pool-alice pgpool-II hostname of 1st pgpool server
DEF_PGPOOL_HOST_ARR[1] pool-bob pgpool-II hostname of 2nd pgpool server (only when using watchdog)
DEF_REPLICATION_MODE stream pgpool-II pgpool's replication mode
DEF_PGPOOL_WATCHDOG yes pgpool-II use watchdog or not
DEF_delegate_IP '192.168.1.123' pgpool-II virtual IP address (only when using watchdog)
DEF_BACKEND_HOST_ARR[n] db-alice PostgreSQL hostname of nth PostgrteSQL server
DEF_BACKEND_PORT_ARR[n] 5432 PostgreSQL port number of nth PostgreSQL server
DEF_PGDATA_ARR[n] /var/lib/pgsql/alice-data PostgreSQL data directory of nth PostgreSQL server
DEF_ARCHIVE_DIR_ARR[n] /var/lib/pgsql/alice-arc PostgreSQL archive directory of nth PostgreSQL server
NETMASK 255.255.255.0 PostgreSQL netmask
DEF_PG_ADMIN_USER admin pgpoolAdmin user for pgpoolAdmin
DEF_PG_ADMIN_USER_PASSWORD pgpool pgpoolAdmin password for pgpoolAdmin's user

pgpool-ii-installer's People

Contributors

yuta-masano avatar tatsuo-ishii avatar

Watchers

James Cloos avatar Yugo Nagata avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.