[Pgpool-general] Replication problem

[Łukasz Jagiełło]

2008/12/18 Łukasz Jagiełło <lukasz.jagiello at gforces.pl>:
> Hi,
>
> Got 2 working datebase. Both at same Amazon EC2 computers. One DB
> disconnect and want to sync it back, so I made:
[...]
> Why that didn't work ?

Also try "Online recovery with rsync" (from
http://pgpool.projects.postgresql.org/) same result:

#v+
2008-12-18 02:35:42 LOG:   pid 25306: starting recovering node 1
2008-12-18 02:35:45 LOG:   pid 25306: CHECKPOINT in the 1st stage done
2008-12-18 02:35:45 LOG:   pid 25306: starting recovery command:
"SELECT pgpool_recovery('pgpool_recovery', '10.X.Y.Z',
'/var/lib/pgsql/data')"
2008-12-18 02:35:46 LOG:   pid 25306: 1st stage is done
2008-12-18 02:35:46 LOG:   pid 25306: starting 2nd stage
2008-12-18 02:35:46 LOG:   pid 25306: all connections from clients
have been closed
2008-12-18 02:35:48 LOG:   pid 25306: CHECKPOINT in the 2nd stage done
2008-12-18 02:35:48 LOG:   pid 25306: starting recovery command:
"SELECT pgpool_recovery('pgpool_recovery', '10.X.Y.Z',
'/var/lib/pgsql/data')"
2008-12-18 02:35:52 LOG:   pid 25306: 1 node restarted
2008-12-18 02:35:52 LOG:   pid 25306: send_failback_request: fail back
1 th node request from pid 25306
2008-12-18 02:35:52 LOG:   pid 25306: recovery done
2008-12-18 02:35:52 LOG:   pid 25256: starting fail back. reconnect
host 10.X.Y.Z(5432)
2008-12-18 02:35:52 LOG:   pid 25256: failover_handler: do not restart
pgpool. same master node 0 was selected
2008-12-18 02:35:52 LOG:   pid 25256: failback done. reconnect host
10.X.Y.Z(5432)
2008-12-18 02:35:52 ERROR: pid 25257: pool_process_query: 1 th kind N
does not match with master connection kind 1
2008-12-18 02:35:52 LOG:   pid 25257: notice_backend_error: 1 fail
over request from pid 25257
2008-12-18 02:35:52 LOG:   pid 25256: starting degeneration. shutdown
host 10.X.Y.Z(5432)
2008-12-18 02:35:52 LOG:   pid 25256: failover_handler: do not restart
pgpool. same master node 0 was selected
2008-12-18 02:35:52 LOG:   pid 25256: failover done. shutdown host
10.X.Y.Z(5432)
#v-


-- 
Łukasz Jagiełło
G-Forces Web Management Polska

T: +44 (0) 845 055 9040
F: +44 (0) 845 055 9038
E: lukasz.jagiello at gforces.pl
W: www.gforces.co.uk

This e-mail is confidential and intended solely for the use of the
individual to whom it is addressed. If you are not the intended
recipient, please notify the sender immediately. Do not disclose the
contents of this e-mail to any other person, use it for any purpose,
print, copy, store, or distribute it. This e-mail should then be
destroyed. Any views expressed in this message are those of the
individual sender except where the sender specifically states them to
be the views of G-Forces Web Management Ltd. Registered Office: 4 & 5
Kings Row, Armstrong Road, Maidstone, Kent. ME15 6AQ. Registered
Company No. 3863609. VAT Registration No. 7250 384 50