[GENERAL] Postgres warm standby in production
Dear friends! Anybody use Postgres 9.5 warm standby in production? Which schemes you use? My setup: - 2 DB servers (master and slave) - 4 APP servers (tomcat) Each tomcat server have JDBC connect to master and prepared config for slave. Business task permit switch between DB server on APP servers manually when failover. What is the best scheme in my configuration? BR, Dmitry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Multi-master replication
Hello All! As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need install BDR module?). I wants to play with multi-master, asynchronous replication on two servers PostgreSQL 9.5 beta 2. In official docs very small information about how to configure servers. Could anyone direct me in right way? BR, Dmitry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Multi-master replication
Just word of month, Thank you Simon for detailed explanation current status of BDR and PostgreSQL. BR, Dmitry On 12/14/2015 09:31 PM, Simon Riggs wrote: On 14 December 2015 at 15:55, Dmitry Mordovin <d.mordo...@dwide.com <mailto:d.mordo...@dwide.com>> wrote: Hello All! As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need install BDR module?). PostgreSQL 9.5 does not yet have the full code required for Bi-Directional replication. How did you hear that? Was that word of mouth, or is that written down anywhere so we can correct it? I wants to play with multi-master, asynchronous replication on two servers PostgreSQL 9.5 beta 2. BDR does exist as production quality software. http://bdr-project.org/docs/stable/index.html BDR 0.93 is compatible with PostgreSQL 9.4. Binary versions are available. Later versions of BDR will be compatible with later versions of PostgreSQL, until the features are fully merged. The full project has taken 4 years so far and we expect it to take another 2 years at least. I'll write a blog about this because there is clearly some confusion around this. In official docs very small information about how to configure servers. Could anyone direct me in right way? If anyone would like to contribute better documentation, they are very welcome to do so. -- Simon Riggs http://www.2ndQuadrant.com/ <http://www.2ndquadrant.com/> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Re: [GENERAL] Multi-master replication
Thank you Merlin, I see this doc too. But I confused, in 9.5 BDR placed to native code and becomes built in feature. So, need I install external BDR or try to config built in version ? Or I didn't understood clearly. BR, Dmitry On 12/14/2015 08:38 PM, Merlin Moncure wrote: On Mon, Dec 14, 2015 at 9:55 AM, Dmitry Mordovin <d.mordo...@dwide.com> wrote: Hello All! As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need install BDR module?). Huh -- that may be so. But if it is, it contradicts the BDR documentation: http://bdr-project.org/docs/stable/install-requirements.html Maybe Andres might know the answer? I wants to play with multi-master, asynchronous replication on two servers PostgreSQL 9.5 beta 2. In official docs very small information about how to configure servers. Could anyone direct me in right way? Have you looked here? https://wiki.postgresql.org/wiki/BDR_Quick_Start merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
