| From: | Yang Zhang <yanghatespam(at)gmail(dot)com> |
|---|---|
| To: | Darren Duncan <darren(at)darrenduncan(dot)net> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: OK to put temp tablespace on volatile storage or to omit it from backups? |
| Date: | 2013-05-01 00:51:18 |
| Message-ID: | CAKxBDU_Gtxs7kb9VEEdpN69hNrey-Gys80=czWLV5P8b56tBVg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)darrenduncan(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Lawrence Barwick | 2013-05-01 02:14:25 | Re: OK to put temp tablespace on volatile storage or to omit it from backups? |
| Previous Message | Darren Duncan | 2013-05-01 00:31:04 | Re: OK to put temp tablespace on volatile storage or to omit it from backups? |