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

From Yang Zhang
Subject Re: OK to put temp tablespace on volatile storage or to omit it from backups?
Date
Msg-id CAKxBDU_Gtxs7kb9VEEdpN69hNrey-Gys80=czWLV5P8b56tBVg@mail.gmail.com
Whole thread Raw
In response to Re: OK to put temp tablespace on volatile storage or to omit it from backups?  (Darren Duncan <darren@darrenduncan.net>)
Responses Re: OK to put temp tablespace on volatile storage or to omit it from backups?  (Ian Lawrence Barwick <barwick@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Darren Duncan
Date:
Subject: Re: OK to put temp tablespace on volatile storage or to omit it from backups?
Next
From: Ian Lawrence Barwick
Date:
Subject: Re: OK to put temp tablespace on volatile storage or to omit it from backups?