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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
