Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45973=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bzO0Y-0000F3-8b
	for pgsql-admin@arkaria.postgresql.org; Wed, 26 Oct 2016 13:12:42 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45973=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bzO0W-0007If-QX
	for pgsql-admin@arkaria.postgresql.org; Wed, 26 Oct 2016 13:12:40 +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.84_2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1bzNyq-0005Mz-Jj
	for pgsql-admin@postgresql.org; Wed, 26 Oct 2016 13:10:56 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1bzNyn-0007p4-7i
	for pgsql-admin@postgresql.org; Wed, 26 Oct 2016 13:10:55 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id u9QDAng1016414;
	Wed, 26 Oct 2016 09:10:49 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Poul Kristensen <bcc5226@gmail.com>
cc: Scott Mead <scottm@openscg.com>, pgsql-admin@postgresql.org
Subject: Re: PostgresSQL 9.5 and systemd autorestart but without replication.
In-reply-to: 
 <CAAOuvVoZofQj+3w5cz0Jwgue_6HdSa5geCYUX-0H3pWZ=YyHXg@mail.gmail.com>
References: 
 <CAAOuvVq+_UNO2su0eEzKSQsZzVqZ2MaXqo=nceGB1VFgh8Z5CQ@mail.gmail.com>
 <CAAD=pwEvuFc513-yrqxb6d9m4rw1Yzh4Xg4AW317aTWOynzBiA@mail.gmail.com>
 <CAAOuvVp5pck9C6x7ycvBnbkx6nW_cZce1gOeWURuDT-4fdquPw@mail.gmail.com>
 <CAAOuvVpAGBfDXtkg5ChVgHAw6Drt4+Z4B5ejV7+HOJ=O13uxwQ@mail.gmail.com>
 <CAKq0gvJwjMD28XFPrzCf-XD0GBYmYwH8X6dCOuCcsN5fSfY1iw@mail.gmail.com>
 <CAAOuvVqm1m=n0OUfypxQBeKsTtvgg-0H3BbQFq3dQE=7VOm7sA@mail.gmail.com>
 <CAAOuvVpXUfvNYNzutqAd4udpAUOA6ekZ=MnqcBRV+-=ZvFc_mw@mail.gmail.com>
 <CAAOuvVoGURYNASEbxgftWUwefDkrrPUwwEWbR4vmYDXjG=dJUQ@mail.gmail.com>
 <CAAOuvVpnHRN0xqjPp6xOWu=x+XE+dMfFB74oM54-JAJX7_Byvg@mail.gmail.com>
 <CAAOuvVoZofQj+3w5cz0Jwgue_6HdSa5geCYUX-0H3pWZ=YyHXg@mail.gmail.com>
Comments: In-reply-to Poul Kristensen <bcc5226@gmail.com>
	message dated "Wed, 26 Oct 2016 11:57:46 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <16412.1477487449.1@sss.pgh.pa.us>
Date: Wed, 26 Oct 2016 09:10:49 -0400
Message-ID: <16413.1477487449@sss.pgh.pa.us>
X-Pg-Spam-Score: -3.2 (---)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Poul Kristensen <bcc5226@gmail.com> writes:
> Replica(hot_standby) server:
> Is it normal behavior that PostgreSQL 9.6 does  a very very slow
> recovery restart point at 1/77472E5 in the pg_log
> while doing this
>  postgres: startup process   recovering 000000010000000100000077(this
> process has run several days)

If that's the standby server, that process will persist as long as it's in
standby; it's what's responsible for applying WAL received by the
walreceiver process.  You should have been able to connect long before
now, though.

			regards, tom lane


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin