[Pgpool-general] Basics of replication with pgpool-II - how does it work? compared to Slony? to Postgres log shipping?

[Tatsuo Ishii]

> > Currently pgpool-II just detects number of affected raws by
> > INSERT/UPDATE/DELETE and reports errors. Next verion of pgpool-II will
> > allow user to choose degeneration in this case or not in addition to
> > reporting errors.
> So the only check I have in load balance mode is the health check? There
> is no data integrity checks?

Yes.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> - -Ramon
> 
> 
> > --
> > Tatsuo Ishii
> > SRA OSS, Inc. Japan
> > English: http://www.sraoss.co.jp/index_en.php
> > Japanese: http://www.sraoss.co.jp
> > 
> >> I am concerned because I have an environment with seven backends in
> >> load_balance_mode and it seems I can not be sure of the data integrity
> >> of these backends in this mode.
> >>
> >> - -Ramon
> >>
> >>
> >>>
> >>>> If that's not how pgpool-II replication works, how does
> >>>> it work?  I've looked at the manual but I still don't
> >>>> understand.
> >>>>
> >>>> I'm familiar with replication with Postgres 8 log shipping
> >>>> (warm standby),  Postgres 9 streaming replication
> >>>> (hot standby), and Slony (hot standby).  How does
> >>>> Pgpool-II replication work and how does it compare to
> >>>> the Postgres/Slony replication?
> >>>
> >>> They are all log(physical or logical one) based asynchronous
> >>> replication systems. Pgpool-II is a query based synchronous
> >>> replication.  That's the big difference. In addition, those
> >>> replication systems do not have any automatic failover/load balancing
> >>> functionality while pgpool-II has.
> >>> --
> >>> Tatsuo Ishii
> >>> SRA OSS, Inc. Japan
> >>> English: http://www.sraoss.co.jp/index_en.php
> >>> Japanese: http://www.sraoss.co.jp
> >>> _______________________________________________
> >>> Pgpool-general mailing list
> >>> Pgpool-general at pgfoundry.org
> >>> http://pgfoundry.org/mailman/listinfo/pgpool-general
> >> -----BEGIN PGP SIGNATURE-----
> >> Version: GnuPG v1.4.10 (GNU/Linux)
> >> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
> >>
> >> iEYEARECAAYFAkwO2uMACgkQGIS0iEuhp4NKNwCeNFbkyQ8z6j+DkOkDKQaPCX3n
> >> 6qgAoKEJUd4zZQ7jJvIX8EquM+CfNQv8
> >> =aW9f
> >> -----END PGP SIGNATURE-----
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
> 
> iEYEARECAAYFAkwPElgACgkQGIS0iEuhp4P2aQCgqdwg8RvLNuUmLdIhWlHGoiBC
> EHwAniWa7M6iPorxh91Pc7amtwH8JRhO
> =VZYN
> -----END PGP SIGNATURE-----