[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] OK to put temp tablespace on volatile storage or to omit it from backups?
From:       Yang Zhang <yanghatespam () gmail ! com>
Date:       2013-04-30 23:55:34
Message-ID: CAKxBDU_Rkb2vOFaj1bGNHYHg0JPOZnM_bWUOOnX9_cHzhR5E9w () mail ! gmail ! com
[Download RAW message or body]

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.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]