Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lCQHZ-0006V4-7j for pgsql-bugs@arkaria.postgresql.org; Wed, 17 Feb 2021 17:06:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lCQHY-0005Ex-50 for pgsql-bugs@arkaria.postgresql.org; Wed, 17 Feb 2021 17:06:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lCQHX-0005Eq-Qm for pgsql-bugs@lists.postgresql.org; Wed, 17 Feb 2021 17:06:31 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lCQHV-0004cA-DG for pgsql-bugs@lists.postgresql.org; Wed, 17 Feb 2021 17:06:30 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.nyi.internal (Postfix) with ESMTP id 72E255C00B8; Wed, 17 Feb 2021 12:06:28 -0500 (EST) Received: from imap21 ([10.202.2.71]) by compute2.internal (MEProxy); Wed, 17 Feb 2021 12:06:28 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= mime-version:message-id:in-reply-to:references:date:from:to :subject:content-type; s=fm1; bh=rEvxHTROJyiqD9rOVJPL+w0VWIyo6y9 WOauYfb/RJic=; b=83tPY1WtLHuuHhFrlaj/nwr9hjXjjLYMYgpCl2lbEeBL3r+ IapGzbHmVUHvzmGywCTgMVZFQ8as4lQVTsMnNhtELtGHor58uIwfj/n6XrBnbLHq o+MN+QcQPaWaODWHgJ5Nu8t/nbVQH4TGXLQsI0aX/dx8DfAcjassJJcpjazUa0UG UzwC23AXSXazvdSD+yecYYNhW5z6hR9NOqJWO6e9oiz0JwX6iw/FB8vVEZtpPqRJ opPTh4JQCCjka88DsOtqX0f9t5p39qG6wkvcy/vGRTbnyOA7szBR8noWWO9/abVy y9JmAl0yeG21VW516LHa248OZfEZOptvJILk2JA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=rEvxHT ROJyiqD9rOVJPL+w0VWIyo6y9WOauYfb/RJic=; b=MdK+dHQ8rV89eBdztGJDlu Cd88LHdaVrigsTQXMWYNlC+RVGkXmqkdx4N8BpM+XG+EYC3xf4pPso3orGp9smC8 2UXjY1g/LDs7Z4poH/BalunADpD13un3KaIwMSb+rsu9W1WQzZmVZuHuJHvnTZhm WYmioimUEXGWoyzaCSmfgZPMdbQ7SXfXkjzi3N2+Qzq5hjKqSBcAZ973AmFr4pcp dZ0Uk/+zfBWqZZLz5jjgsUOUXumQnn7W5Es7/bvJ/fmNq42czIbuHGkJhRkJnLmp 3HkhBMs+AnivqxsfjgyiWIhLKrPqKqEB9joUY5ZlcWCy2abrc4tn5nTJ3me4qNcQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrjedvgdejudcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefofgggkfgjfhffhffvufgtsegrtderreerredtnecuhfhrohhmpedfgfhulhgv rhcuvfgrvhgvihhrrgdfuceovghulhgvrhesvghulhgvrhhtohdrtghomheqnecuggftrf grthhtvghrnheptdejffeiueeigeegheeiuedtveelteetjeeitdfgheehfeeukeevffet udejhfffnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghdpvghnthgvrhhprh hishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghi lhhfrhhomhepvghulhgvrhesvghulhgvrhhtohdrtghomh X-ME-Proxy: Received: by mailuser.nyi.internal (Postfix, from userid 501) id 2E61451C005D; Wed, 17 Feb 2021 12:06:27 -0500 (EST) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.5.0-alpha0-141-gf094924a34-fm-20210210.001-gf094924a Mime-Version: 1.0 Message-Id: <5cf0ba4e-5d4d-40da-b17f-ae37fea9c388@www.fastmail.com> In-Reply-To: <001501d704cf$b9979760$2cc6c620$@specialisedstructures.co.nz> References: <001501d704cf$b9979760$2cc6c620$@specialisedstructures.co.nz> Date: Wed, 17 Feb 2021 14:06:00 -0300 From: "Euler Taveira" To: "Gareth Vaughan" , pgsql-bugs@lists.postgresql.org Subject: Re: PITR restores incorrect state Content-Type: multipart/alternative; boundary=fea04d78407648cba54802c8455dd092 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --fea04d78407648cba54802c8455dd092 Content-Type: text/plain On Tue, Feb 16, 2021, at 10:53 PM, Gareth Vaughan wrote: > 10) in an elevated cmd run these: > net stop postgresql-x64-13 > DEL /F/Q/S "c:\Program Files\PostgreSQL\13\data\*" > NUL > RMDIR /Q/S "c:\Program Files\PostgreSQL\13\data\" > mkdir "c:\Program Files\PostgreSQL\13\data\" > xcopy C:\temp\pitr_test\base_backup\* "c:\Program Files\PostgreSQL\13\data\" /e /q > icacls "c:\Program Files\PostgreSQL\13\data" /grant postgres:(OI)(CI)F > net start postgresql-x64-13 > This is not a bug. Your forgot step 7: create a $PGDATA/recovery.signal [1]. It was changed in version 12 when the recovery settings was moved to postgresql.conf. [1] https://www.postgresql.org/docs/13/continuous-archiving.html#BACKUP-PITR-RECOVERY -- Euler Taveira EDB https://www.enterprisedb.com/ --fea04d78407648cba54802c8455dd092 Content-Type: text/html Content-Transfer-Encoding: quoted-printable
On Tue, Fe= b 16, 2021, at 10:53 PM, Gareth Vaughan wrote:

10) in a= n elevated cmd run these:

net stop postgresql-x6= 4-13

DEL /F/Q/S "c:\Program Files\PostgreSQL\13\= data\*" > NUL

RMDIR /Q/S "c:\Program Files\Po= stgreSQL\13\data\"

mkdir "c:\Program Files\Postg= reSQL\13\data\"

xcopy C:\temp\pitr_test\base_bac= kup\* "c:\Program Files\PostgreSQL\13\data\" /e /q

=

icacls "c:\Program Files\PostgreSQL\13\data" /grant postgres:(OI)(CI)= F

net start postgresql-x64-13
<= /p>

 

This is not a = bug. Your forgot step 7: create a $PGDATA/recovery.signal [1]. It
was changed in version 12 when the recovery settings was moved = to           &nbs= p;  
postgresql.conf.

[1] https://www.postgresql.org/docs/13/continuo= us-archiving.html#BACKUP-PITR-RECOVERY

=
--
Euler Taveira

--fea04d78407648cba54802c8455dd092--