[Pgpool-general] pgpool-II 2.2 RC2 released

[Jaume Sabater]

On Mon, Feb 23, 2009 at 9:34 AM, Jaume Sabater <jsabater at gmail.com> wrote:

> This is what pgpool-II left on the syslog:

[..]

Tried a second time, users querying the database while the online
recovery was happening. Same error. Then changed the parameter
"recovery_timeout" to "90" in pgpool.conf and reloaded with
/etc/init.d/pgpool2 reload. Tried again, and it worked. According to
the PostgreSQL log in the master node, no query was sent to the server
while the online recovery was happening (pure coincidence).

Here you are the log from pgpool-II:

Feb 23 09:37:55 pgsql1 pgpool: LOG:   pid 1155: starting recovering node 1
Feb 23 09:37:55 pgsql1 pgpool: LOG:   pid 1155: CHECKPOINT in the 1st
stage done
Feb 23 09:37:55 pgsql1 pgpool: LOG:   pid 1155: starting recovery
command: "SELECT pgpool_recovery('base-backup',
'pgsql2.freyatest.domain', '/var/lib/postgresql/8.3/main')"
Feb 23 09:37:55 pgsql1 pgpool[1506]: Executing base-backup as user postgres
Feb 23 09:37:55 pgsql1 pgpool[1507]: Executing pg_start_backup
Feb 23 09:37:55 pgsql1 pgpool[1510]: Creating file recovery.conf
Feb 23 09:37:55 pgsql1 pgpool[1511]: Rsyncing directory base
Feb 23 09:37:55 pgsql1 pgpool[1514]: Rsyncing directory global
Feb 23 09:37:55 pgsql1 pgpool[1517]: Rsyncing directory pg_clog
Feb 23 09:37:55 pgsql1 pgpool[1520]: Rsyncing directory pg_multixact
Feb 23 09:37:55 pgsql1 pgpool[1524]: Rsyncing directory pg_subtrans
Feb 23 09:37:55 pgsql1 pgpool[1527]: Rsyncing directory pg_tblspc
Feb 23 09:37:56 pgsql1 pgpool[1530]: Rsyncing directory pg_twophase
Feb 23 09:37:56 pgsql1 pgpool[1533]: Rsyncing directory pg_xlog
Feb 23 09:37:57 pgsql1 pgpool[1536]: Rsyncing file recovery.conf (with
source deletion)
Feb 23 09:37:58 pgsql1 pgpool[1539]: Executing pg_stop_backup
Feb 23 09:37:58 pgsql1 pgpool: LOG:   pid 1155: 1st stage is done
Feb 23 09:37:58 pgsql1 pgpool: LOG:   pid 1155: starting 2nd stage
Feb 23 09:37:58 pgsql1 pgpool: LOG:   pid 1155: all connections from
clients have been closed
Feb 23 09:37:58 pgsql1 pgpool: LOG:   pid 1155: CHECKPOINT in the 2nd
stage done
Feb 23 09:37:58 pgsql1 pgpool: LOG:   pid 1155: starting recovery
command: "SELECT pgpool_recovery('pgpool-recovery-pitr',
'pgsql2.freyatest.domain', '/var/lib/postgresql/8.3/main')"
Feb 23 09:37:58 pgsql1 pgpool[1547]: Executing pgpool-recovery-pitr as
user postgres
Feb 23 09:37:58 pgsql1 pgpool[1548]: Executing pg_switch_xlog
Feb 23 09:37:58 pgsql1 pgpool[1552]: pg_switch_xlog executed successfully.
Feb 23 09:37:58 pgsql1 pgpool[1556]: Executing pgpool_remote_start as
user postgres
Feb 23 09:37:58 pgsql1 pgpool[1557]: Starting remote PostgreSQL server
Feb 23 09:38:03 pgsql1 pgpool: LOG:   pid 1155: 1 node restarted
Feb 23 09:38:03 pgsql1 pgpool: LOG:   pid 1155: send_failback_request:
fail back 1 th node request from pid 1155
Feb 23 09:38:03 pgsql1 pgpool: LOG:   pid 1116: starting fail back.
reconnect host pgsql2.freyatest.domain(5432)
Feb 23 09:38:03 pgsql1 pgpool: LOG:   pid 1116: execute command:
/var/lib/postgresql/8.3/main/pgpool-failback 1 pgsql2.freyatest.domain
5432 /var/lib/postgres
ql/8.3/main 0 0
Feb 23 09:38:03 pgsql1 pgpool[1590]: Executing pgpool-failback as user postgres
Feb 23 09:38:03 pgsql1 pgpool[1591]: Failback of node 1 at hostname
pgsql2.freyatest.domain. New master node is 0. Old master node was 0.
Feb 23 09:38:03 pgsql1 pgpool: LOG:   pid 1116: failover_handler: set
new master node: 0
Feb 23 09:38:03 pgsql1 pgpool: LOG:   pid 1116: failback done.
reconnect host pgsql2.freyatest.domain(5432)
Feb 23 09:38:03 pgsql1 pgpool: LOG:   pid 1155: recovery done

Was it me, or pgpool-II? :-S

-- 
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"