[pgpool-general: 3095] prevent_data_loss
oniesner
oniesner at micromata.de
Mon Aug 11 16:47:55 JST 2014
Hi all,
I' m new to pgpool and managed to run pgpool(3.3.3) with three
postgresql (9.1.3) databases in streaming replication mode like this:
procpid | usesysid | usename | application_name | client_addr |
client_hostname | client_port | backend_start | state
| sent_location | write_location | flush_location | replay_location |
sync_priority | sync_state
---------+----------+----------+------------------+---------------+-----------------+-------------+-------------------------------+-----------+---------------+----------------+----------------+-----------------+---------------+------------
4329 | 10 | postgres | walreceiver | 192.168.77.44 |
| 36235 | 2014-08-11 02:24:10.278354-05 | streaming |
0/2000D300 | 0/2000D300 | 0/2000D300 | 0/2000D300 |
0 | async
3441 | 10 | postgres | walreceiver | 192.168.77.60 |
| 39303 | 2014-08-11 02:04:31.181787-05 | streaming |
0/2000D300 | 0/2000D300 | 0/2000D300 | 0/2000D300 |
0 | async
(2 Zeilen)
This works very fine, if some of the slaves going down the data got
immediately got restored when the slave comes back online.
For my goal it is absolutely necessary that no data loss occurs
whatever happens.
I found out that data loss happens when the master goes down(crashes)
and one of the other nodes take over.
My question is:
Is there a setup which prevent data loss when the master crashes?
thanks in advance,
Oliver
More information about the pgpool-general
mailing list