[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