Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2009-05-31 17:50:52
Subject: Re: check for missing tablespaces?
Previous:From: Stephen FrostDate: 2009-05-31 17:23:46
Subject: Re: check for missing tablespaces?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group