| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Andrew Chernow <ac(at)esilo(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: check for missing tablespaces? |
| Date: | 2009-05-31 19:53:13 |
| Message-ID: | 4A22E029.40304@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Andrew Chernow wrote:
> Andrew Dunstan wrote:
>>
>> 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,
> Have you uncovered why the tablespace went missing?
No. It's on a SAN, and I understand our hardware guys are talking to the
SAN vendor to get to the bottom of it. The network in the data centre
was reconfigured last night, but that should not in fact have affected
the SAN AFAIK. Other SAN devices mounted quite happily, including the
one containing the main data directory.
Anyway, from this POV all we really need to know is that the device
hosting this tablespace failed to mount when the machine was rebooted,
and then postgres restarted.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri Fontaine | 2009-05-31 19:58:28 | Re: Feedback on writing extensible modules |
| Previous Message | Brian Klish | 2009-05-31 19:49:39 | PostgreSQL 8.4 beta 2 restore error |