Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxwHS-00076b-Tc for pgsql-admin@arkaria.postgresql.org; Thu, 06 Sep 2018 15:33:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fxwHQ-0004ds-Q7 for pgsql-admin@arkaria.postgresql.org; Thu, 06 Sep 2018 15:33:12 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxwHQ-0004dd-2P for pgsql-admin@lists.postgresql.org; Thu, 06 Sep 2018 15:33:12 +0000 Received: from resqmta-ch2-09v.sys.comcast.net ([2001:558:fe21:29:69:252:207:41]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxwHM-0004uL-Ng for pgsql-admin@postgresql.org; Thu, 06 Sep 2018 15:33:10 +0000 Received: from resomta-ch2-20v.sys.comcast.net ([69.252.207.116]) by resqmta-ch2-09v.sys.comcast.net with ESMTP id xt3HfKw8nhahoxwHLfacgO; Thu, 06 Sep 2018 15:33:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20161114; t=1536247987; bh=8dVbJ/YKLCafrhQr8oCqfBK++S7sZxXs5UfhHYCND+k=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=npHmCiGLE9t5pit6RVqrDEWNJeXy1jv6pr/RZyNHWs3pTBdLGTa0HYL+KTdBVnZTW Bv9vPqqy0fhPsFmTjt7ZCYasXd+syIuQdve8VPHpvohI3gHwhY9QJ0F0W3bsbymkIY ZYx+8Aeqb6IW1+K6ardqEQD2NGaR7PdoM0xsXjWAQdcPTRXJt72S7eaDt7c/d8mUvd XgHCHewyvm+D3WhPQUBCHK1iinEr3djTkXhJhkhQen+yOk9gOJ0rtWWlYJQYi0UfJ6 oCy/xHj1QSOv+i1h/fWceLbHjH/OJ8D8pThvGbDioZZaXZWjNkM8F40U7seL3L/ydq SCuAhJzU6w+Pg== Received: from jsievers.comcast.net ([12.187.116.132]) by resomta-ch2-20v.sys.comcast.net with ESMTPA id xwHCfRMLH5BOmxwHDfDzWp; Thu, 06 Sep 2018 15:33:05 +0000 Received: from jsievers.enova.com (localhost [127.0.0.1]) by jsievers.comcast.net (Postfix) with ESMTP id 88089260056; Thu, 6 Sep 2018 10:32:58 -0500 (CDT) From: Jerry Sievers To: amit tripathi Cc: pgsql-admin@postgresql.org Subject: Re: recovery.conf not getting changed to recovery.done after PITR References: Date: Thu, 06 Sep 2018 10:32:58 -0500 In-Reply-To: (amit tripathi's message of "Thu, 6 Sep 2018 10:43:40 +0530") Message-ID: <871sa6y72t.fsf@jsievers.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-CMAE-Envelope: MS4wfAUUFYe2a8qzdbcxfdPQx4XQBsBa8zRKRA9/ykdi8NgnKamciehkUGFEyXS/lwXLFks5krqwRjfynQ10cs3QW/WyVhW1Xk/4DPUaf31MhHw87QI/nwMx pfwVplNNTLrxBaneclaTOji8+w6SZDIo/w93ZlxH8fPaiubC21hyyFhSCqMybLYT15UrrOn47/4djmEsqeYlZHYHx9hoId7L4XpsxgSZlgnPjoOLQh+2mwV9 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk amit tripathi writes: > Hi All, > > Need help on below issue. > >>In recovery.conf file if we give=C2=A0recovery_target_time as=C2=A0 2018-= 09-05 > 09:54:21 (without EST)=C2=A0 and restart the postgresql, recovery.conf is > not getting changed to recovery.done. Although PITR is successful and > only till given time records/tables are restored. But database goes > in recovery mode and i am unable to enter more records. Show us your recovery.conf after masking anything sensitive. You probably are paused at a recovery target and if trying to promote the pitr cluster at this point, need to un-pause replication else it will not respond to the promote. HTH > >>In the second case if i add EST and restart the postgresql, > recovery.conf is getting changed to recovery.done but everything is > getting restored. I mean tables/records added after 2018-09-05 > 09:54:21 are also restored. > > Other information-Doing it on Linux host. Timezone in postgresql.conf > is=C2=A0US/Eastern. > > > Regards, > Amit > > --=20 Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 312.241.7800