Re: PITR restores incorrect state - Mailing list pgsql-bugs

From Euler Taveira
Subject Re: PITR restores incorrect state
Date
Msg-id 5cf0ba4e-5d4d-40da-b17f-ae37fea9c388@www.fastmail.com
Whole thread Raw
In response to PITR restores incorrect state  ("Gareth Vaughan" <gareth@specialisedstructures.co.nz>)
List pgsql-bugs
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.



--
Euler Taveira

pgsql-bugs by date:

Previous
From: "Euler Taveira"
Date:
Subject: Re: BUG #16868: Cannot find sqlstat error codes.
Next
From: bipsy Nair
Date:
Subject: Re: BUG #16868: Cannot find sqlstat error codes.