code:notes:postgresnotomorrow.de

== Postgres replication install

=== debian

requirements

apt-get install wget get build-essential libkrb5-dev
apt-get install libxslt-dev libxml2-dev libpam-dev libedit-dev

wget -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | apt-key add -
apt-get install postgresql-9.1
echo "deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main" \
  >> /etc/apt/sources.list.d/pgdg.list

(cat <<-DEMO
Package: *
Pin: release o=apt.postgresql.org
Pin-Priority: 500
DEMO
) >> /etc/apt/preferences.d/pgdg.pref

apt-get update
apt-get install pgdg-keyring
apt-get install postgresql-9.2 postgresql-server-dev-9.2

repmgr

git clone git://github.com/2ndQuadrant/repmgr.git
cd repmgr
make clean
make USE_PGXS=1
make USE_PGXS=1 install

update-alternatives --install /usr/bin/repmgr repmgr /usr/lib/postgresql/9.2/bin/repmgr 10
update-alternatives --install /usr/bin/repmgr repmgr /usr/lib/postgresql/9.2/bin/repmgrd 10

=== centos

yum install repmgr

repmgr               x86_64               1.2.0-1.rhel6                 pgdg91                59 k