Postgres Pro
Downloads
Home   >   mailing lists

OK to put temp tablespace on volatile storage or to omit it from backups? - Mailing list pgsql-general

From Yang Zhang
Subject OK to put temp tablespace on volatile storage or to omit it from backups?
Date
Msg-id CAKxBDU_Rkb2vOFaj1bGNHYHg0JPOZnM_bWUOOnX9_cHzhR5E9w@mail.gmail.com
Whole thread Raw
Responses Re: OK to put temp tablespace on volatile storage or to omit it from backups?  (Darren Duncan <darren@darrenduncan.net>)
Re: OK to put temp tablespace on volatile storage or to omit it from backups?  (Julian Glass <tempura@internode.on.net>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Simple SQL INSERT to avoid duplication failed: why?
Next
From: Darren Duncan
Date:
Subject: Re: OK to put temp tablespace on volatile storage or to omit it from backups?