Search Postgresql Archives

Re: Online recovery of Tablespace

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, May 22, 2014 at 2:41 AM, Sameer Kumar <sameer.kumar@xxxxxxxxxx> wrote:
Hi,

I am designing backup strategy for a PostgreSQL database (v9.3). I have a scenario for recovery of tablespaces:

1. Backup of whole database (including individual tablespaces which are stored on different disks) has been taken at 11AM

2. My disk which stores tablespace- tblspc1 crashed at 2:00PM

3. Can I restore the backup of 11AM (only for one tablespace) and then recover that tablespace to 2:00PM state?


Is this possible? I have attached the steps I tried (I believe logically my steps are wrong, since I am using recovery.conf but I am not replacing data directory).

But is there any way to specify in recovery.conf or otherwise that I would allow me to do recovery of transactions of a particular tablespace? A custom solution which occurs to me is using pg_xlogdump contrib. Has anyone tried something similar?


We do not support recovering just one tablespace. You have to recover the whole database.

(I see that you are using EnterpriseDB's propietary version based on the paths, but I don't believe they have made any such extensions either) 


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux