Teórico de colores

17.02.09

Pgpool-II for beginners Table of Contents
prerequisite...........................................................................................................................................2 introduction...........................................................................................................................................2installation............................................................................................................................................3 configuration.........................................................................................................................................3 start/stoppgpool...................................................................................................................................4 initial replication setup.........................................................................................................................4 copy database ..................................................................................................................................4 startingup........................................................................................................................................4 check if replication is working.............................................................................................................5 Initial situation.................................................................................................................................5 create a test database and insert somedata......................................................................................5 check data in each node...................................................................................................................5 failure example.....................................................................................................................................5 Onlinerecovery....................................................................................................................................7 enable online recovery.....................................................................................................................7 creating scripts used by online recovery..........................................................................................7copy_base_backup......................................................................................................................8 pgpool_recovery_pitr..................................................................................................................8pgpool_remote_start....................................................................................................................8 initiate online recovery....................................................................................................................9

--------------------------------------------------------------------Copyright (c) 2009 PgPool Global Development Group Original text written by Gerd Koenig please send comments to: gk_ulm at web.de----------------------------------------------------------------------

Gerd Koenig

1/12

pgpool-II for beginners

17.02.09

prerequisite
•postgresql headerfiles (postgresql-devel-8.3.5-2.1.x86_64.rpm) •libpq.so (check /usr/lib64/libpq*) •make,gcc

introduction
•There are 2 servers, identical hardware, shared nothing with installed OpenSuse10.3 (64bit). •existing ssh-key-exchange from node1 → node2 •PostgreSQL8.3.5, PGDATA =/opt/postgres/data •In this guide pgpool will be installed under directory /opt/pgpoolII, adjust the parameter „--prefix“ if you want to install to a different location. •This tutorial covers the usage of replication mode only ! •I strongly recommend to read the documentation at http://pgpool.projects.postgresql.org/ to get as much information as possible about pgpool •Please keep in mind that the pgpool...