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: (view raw, whole thread or download thread mbox)
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

			regards, tom lane

In response to


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-2017 The PostgreSQL Global Development Group