----------------eredeti üzenet-----------------
Feladó: "Chris Travers" [email protected]
Címzett: "Pongrácz István"
CC: "Ledger-smb-devel lists.sourceforge.net"
[email protected]
Dátum: Sat, 2 Nov 2013 19:54:50 -0700
----------------------------------------------------------
>
>
>Given that almost everything comes in as a SELECT statement, it does not
>surprise me
>that you are limited to transaction mode.
>
>
>
>I am not really sure what you are trying to achieve from PGBouncer, and might
>be useful as
>a piece of a high availability environment, but I don't think it is going to
>have the
>information required to determine what can be safely sent to the read-only
>replica.
>
>--
>
>Best Wishes,
>
>Chris Travers
>
>
>
>Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.
>
>[http://www.efficito.com/learn_more.shtml ->
>http://www.efficito.com/learn_more.shtml]
>
>
>
>
>
>Hi Chris,
>
>PGbouncer has nothing to do with the replica.
>
>The replication happens between the two postgresql databases (master->slave
>with
>sync streaming replication), pgbouncer only manage that, which is the master.
>There is a
>utility, which manages the failover situation safely (failoverd).
>
>The basic function (sync stream replication from master to slave) is working
>well
>without involving pgbouncer and failoverd, now I can step further to HA.
>
>Bye,
>
>István
>
>
------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
