Postgres warm standby in production

From: Dmitry Mordovin <d(dot)mordovin(at)dwide(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres warm standby in production
Date: 2016-03-31 10:41:23
Message-ID: 56FCFED3.6060706@dwide.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Nik Mitev 2016-03-31 12:35:41 Is it possible to delete a single value from an enum type?
Previous Message Pavlov, Vladimir 2016-03-31 10:25:41 Re: Multixacts wraparound monitoring