BUG #9422: PostgreSQL Zero downtime during deployement - Mailing list pgsql-bugs

From muhammadk@chetu.com
Subject BUG #9422: PostgreSQL Zero downtime during deployement
Date
Msg-id 20140303135215.2160.16656@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #9422: PostgreSQL Zero downtime during deployement
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      9422
Logged by:          Muhammad Khalid
Email address:      muhammadk@chetu.com
PostgreSQL version: 9.2.1
Operating system:   CentOS
Description:

We need some idea about how can we deploy a financial application in
production environment using PostgreSQL DB with zero down time. I have two
servers in Master-Slave design. Currently we are giving downtime while
deploying applications and executing database script. For zero downtime, do
we need any configuration or any third party software or PostgreSQL utility
which will handle this scenario so that in production real time environment
we don't lose any transactions and I also can update database script
simultaneously?

pgsql-bugs by date:

Previous
From: pboake@gmail.com
Date:
Subject: BUG #9416: Setting up postgresql-9.1 (9.1.12-0wheezy1) Fails Configuration
Next
From: proels@web.de
Date:
Subject: BUG #9420: WAL-Sender repeatedly killed