Subject: Re: How to tell if PGSQL 8.4 is in standby mode
To: pgsql-admin@lists.postgresql.org
References: <002701d3d529$76a8dd70$63fa9850$@telium.ca>
 <037ec8bb-72d2-b0c3-d218-2211c9b5e3cf@catalyst.net.nz>
 <257d168e-8c50-f85c-fffd-5c90fe02f09e@gmail.com>
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Message-ID: <8d71ebd3-79a1-2a2e-546d-10cbea13c656@catalyst.net.nz>
Date: Tue, 17 Apr 2018 09:22:09 +1200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.7.0
MIME-Version: 1.0
In-Reply-To: <257d168e-8c50-f85c-fffd-5c90fe02f09e@gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk


On 17/04/18 00:53, Ron wrote:
> On 04/16/2018 03:18 AM, Mark Kirkwood wrote:
>>
> [snip]
>>
>> 8.4? Seriously, there are so many reasons to be using a later version!
>
> If the customer says "don't upgrade because we don't want to disturb a 
> running system", then... you don't upgrade.  It's as simple as that.
>
>

Well, left to themselves - all customers will say that. It is up to us 
IT guys to explain to them the benefits of keeping current and the risks 
of not doing so. E,g in this case:
- really hard to tell if standby is up to date
- ...and will actually come up if needed
- hard to get help in the advent of problems (not many people are 
current with 8,.4 replication for instance)

regards
Mark