Re: check for missing tablespaces?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: check for missing tablespaces?
Date: 2009-05-31 17:28:01
Message-ID: 8573.1243790881@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> I am in the middle of helping a customer recover from a situation where
> a tablespace was missing when a machine was rebooted and postgres
> restarted, and I'm wondering if we should not have some sort of check
> for this on startup. Maybe we could check for the existence of the
> PG_VERSION file or something like that?

... and do what?

What exactly went wrong so badly with the missing tablespace? Doesn't
seem like it should be any worse than if individual table files went
missing.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2009-05-31 17:50:52 Re: check for missing tablespaces?
Previous Message Stephen Frost 2009-05-31 17:23:46 Re: check for missing tablespaces?