Re: PITR restores incorrect state

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/

In response to

Browse pgsql-bugs by date

  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.