Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1f83e0-0007jC-7z
	for pgsql-admin@arkaria.postgresql.org; Mon, 16 Apr 2018 12:54:04 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1f83dz-0007IC-8P
	for pgsql-admin@arkaria.postgresql.org; Mon, 16 Apr 2018 12:54:03 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1f83dz-0007Hy-0W
	for pgsql-admin@lists.postgresql.org; Mon, 16 Apr 2018 12:54:03 +0000
Received: from mail-ot0-x244.google.com ([2607:f8b0:4003:c0f::244])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1f83dw-0004m3-1p
	for pgsql-admin@lists.postgresql.org; Mon, 16 Apr 2018 12:54:02 +0000
Received: by mail-ot0-x244.google.com with SMTP id w2-v6so6242958otj.12
        for <pgsql-admin@lists.postgresql.org>;
 Mon, 16 Apr 2018 05:53:59 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=subject:to:references:from:message-id:date:user-agent:mime-version
         :in-reply-to:content-transfer-encoding:content-language;
        bh=apEEiiiG5lQXRWupfFrlIxxJeRqwbrnBaghaLMAUxNQ=;
        b=QVAVrtG5iUqSAivs5RAKMo2sTku7gFyWx3YQH3RsIowF7VxqGfb6BSUbfDEmiqBbom
         ux+dwaGo8gQ3RA2se0X5OACAyyx/qbY4vT7vF1JTfIa8MIVOgDlufrqyQ9w4YdBYF2of
         Ka3Tt/CVPFc9vgjfh66qburn65Wy2Hfr2WkKqi4vh86fbssqH1gS5QhLcbT6SF4eiBjP
         bknzFz6AjnDM/PBhm3+fbgYZNs2EjynFMrGq/LgXO+xq/DGnxZo1avzzd+BHHAEKXupC
         jLRhOuu+WTKl7g4MAYm+oIXKs9r2wSY2OZXpOVIlrTefFnd7AKNY16nzviT0qPzbg3o4
         +dXg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:subject:to:references:from:message-id:date
         :user-agent:mime-version:in-reply-to:content-transfer-encoding
         :content-language;
        bh=apEEiiiG5lQXRWupfFrlIxxJeRqwbrnBaghaLMAUxNQ=;
        b=i7sAmsmQi9J9INBbwXWKVsA9RLrjsabZVucExYtzgtU4574CcdU6o9ajkRF2YGs157
         w+KjfErYCBH597VxRzgf1TKJCQxAcCVJRmrsK2WokGpNDbj3lEB9YbX4kqFx3ahJ8yHv
         biLzJX7VYDAPRJWeJAIRywnhTZgDkVChXA9e6br7IJ+FKaZdtNclQLkwFqBsrIWy5yhM
         UBbdoV+mFd9feaj3Ct954fMEKoFcoRHrxDtKg0rjJ/vrPTJtPEMPWqH/r1ScbM/RV8hb
         ANLhYFkoEgkWOXFfCbWMcsH6rRYJ68FHKzVfSkKEJ8yhhluLPA6T679sVeZi9JnqVUFM
         GsaQ==
X-Gm-Message-State: ALQs6tDt5Mz+/VuvGGSj66gFzPZFrBvpVkN9FLWbTHeN+zGXC/5edaar
	yHh3T4ewUcNetSJugjnh1B4bRQ==
X-Google-Smtp-Source: 
 AIpwx48lPuXR7FpYLRC2HePDutGe3wxcvV/38qo0DUje7ahVLsxpDrk8ImozrrCk15bveZs/X4RRWQ==
X-Received: by 2002:a9d:2dea:: with SMTP id
 g97-v6mr9804687otb.138.1523883237977;
        Mon, 16 Apr 2018 05:53:57 -0700 (PDT)
Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89])
        by smtp.googlemail.com with ESMTPSA id
 v44-v6sm2121167ota.65.2018.04.16.05.53.56
        for <pgsql-admin@lists.postgresql.org>
        (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
        Mon, 16 Apr 2018 05:53:57 -0700 (PDT)
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>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <257d168e-8c50-f85c-fffd-5c90fe02f09e@gmail.com>
Date: Mon, 16 Apr 2018 07:53:56 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.6.0
MIME-Version: 1.0
In-Reply-To: <037ec8bb-72d2-b0c3-d218-2211c9b5e3cf@catalyst.net.nz>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

On 04/16/2018 03:18 AM, Mark Kirkwood wrote:
> Hi, (see below)
>
>
> On 16/04/18 14:20, TSG wrote:
>>
>> I have a PostgreSQL 8.4 database that I'm am trying to start in standby 
>> mode (I am shipping my own logs from the active DB). I /think/ my standby 
>> DB is in standby/recovery mode but I'm not sure how to tell.
[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.


-- 
Angular momentum makes the world go 'round.