Re: Postgres 9.2 PITR testing to before DROP DATABASE ends up removing file system files

On 12/02/2014 03:50 PM, Joshua Boyd wrote:
> Having continued my research, the problem I encountered is the exact
> same that's been recorded here:
>
> https://www.marshut.net/kstxxk/pitr-failing-to-stop-before-drop-database.html
>

>
> I think I answered all the questions - please let me know if I missed
> some.  Based on the url I pasted at the top, though, it appears I'm not
> the only one who's encountered this problem.
>

Re-read the initial post and realized you wanted the state of the
recovered cluster to include the database that was dropped. In that case
I would say stop the recovery just before the DROP DATABASE.

>
> --
> Joshua Boyd


--
Adrian Klaver
adrian.klaver@aklaver.com