From: | "Euler Taveira" <euler(at)eulerto(dot)com> |
---|---|
To: | "Gareth Vaughan" <gareth(at)specialisedstructures(dot)co(dot)nz>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: PITR restores incorrect state |
Date: | 2021-02-17 17:06:00 |
Message-ID: | 5cf0ba4e-5d4d-40da-b17f-ae37fea9c388@www.fastmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
[1] https://www.postgresql.org/docs/13/continuous-archiving.html#BACKUP-PITR-RECOVERY
--
Euler Taveira
EDB https://www.enterprisedb.com/
From | Date | Subject | |
---|---|---|---|
Next Message | bipsy Nair | 2021-02-17 18:01:58 | Re: BUG #16868: Cannot find sqlstat error codes. |
Previous Message | Euler Taveira | 2021-02-17 16:54:03 | Re: BUG #16868: Cannot find sqlstat error codes. |