OK to put temp tablespace on volatile storage or to omit it from backups?

From: Yang Zhang <yanghatespam(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: OK to put temp tablespace on volatile storage or to omit it from backups?
Date: 2013-04-30 23:55:34
Message-ID: CAKxBDU_Rkb2vOFaj1bGNHYHg0JPOZnM_bWUOOnX9_cHzhR5E9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would intuit that it's fine, but I just want to make sure there are
no gotchas from a recovery point of view:

If I were to lose my temp tablespace upon system crash, would this
prevent proper crash recovery?

Also, if I were to omit the temp tablespace from the base backup,
would that prevent proper backup recovery?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darren Duncan 2013-05-01 00:31:04 Re: OK to put temp tablespace on volatile storage or to omit it from backups?
Previous Message Tom Lane 2013-04-30 23:11:32 Re: Simple SQL INSERT to avoid duplication failed: why?