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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Joshua Boyd <joishi(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres 9.2 PITR testing to before DROP DATABASE ends up removing file system files
Date: 2014-12-03 23:37:38
Message-ID: 547F9EC2.9010105@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua Boyd 2014-12-03 23:52:05 Re: Postgres 9.2 PITR testing to before DROP DATABASE ends up removing file system files
Previous Message Adrian Klaver 2014-12-03 23:22:03 Re: Postgres 9.2 PITR testing to before DROP DATABASE ends up removing file system files