BUG #9422: PostgreSQL Zero downtime during deployement

From: muhammadk(at)chetu(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #9422: PostgreSQL Zero downtime during deployement
Date: 2014-03-03 13:52:15
Message-ID: 20140303135215.2160.16656@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 9422
Logged by: Muhammad Khalid
Email address: muhammadk(at)chetu(dot)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?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2014-03-03 15:03:07 Re: BUG #9422: PostgreSQL Zero downtime during deployement
Previous Message proels 2014-03-03 12:53:42 BUG #9420: WAL-Sender repeatedly killed