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

That is unfortunate.  Good thing I asked, I guess.  Do you have a
pointer to said blog post?

On Tue, Apr 30, 2013 at 5:31 PM, Darren Duncan <darren@darrenduncan.net> wrote:
> On 2013.04.30 4:55 PM, Yang Zhang wrote:
>>
>> 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?
>
>
> Although it would be nice if what you said would work, I read in a recent
> blog post that losing any tablespace would prevent the database server from
> starting, even if it was only for temporary things. -- Darren Duncan
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general