Timeline for Recover from Postgres FATAL: could not open file pg_tblspc/
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 2, 2021 at 14:58 | answer | added | Will Peter | timeline score: 4 | |
| Jan 11, 2020 at 9:37 | vote | accept | alfonx | ||
| Jan 11, 2020 at 9:37 | |||||
| Jan 10, 2020 at 16:02 | answer | added | mitel | timeline score: 1 | |
| Oct 17, 2019 at 18:42 | answer | added | bachr | timeline score: 0 | |
| Jan 22, 2018 at 22:45 | answer | added | Bob Chase | timeline score: 1 | |
| Jul 8, 2017 at 12:23 | history | tweeted | twitter.com/StackDBAs/status/883662909435510784 | ||
| Jun 13, 2017 at 20:35 | history | edited | joanolo | CC BY-SA 3.0 |
added 8 characters in body
|
| May 6, 2012 at 18:22 | comment | added | alfonx | Thanks. Two of the tablespaces are RAIDs. I used one tablespace for unimportant tables on a single SSD.. because I thought that that drive could die and the important stuff is on the save RADI-backed tablespaces. I now learned the hard way, that loosing one tablespace can result in no access the whole database. :-/ | |
| May 6, 2012 at 13:30 | comment | added | kgrittn | I cringed when I read the words "multiple tablespaces = physical drives". Please consider RAID for future deployments. We have hundreds of servers, which aren't always replaced on the targeted four-year replacement schedule, so we must have a drive failure at least once per month. Since we use RAID with a hot spare and hot replacement, this rarely affects performance, much less causing a need to go to our backups. | |
| May 6, 2012 at 13:28 | answer | added | kgrittn | timeline score: 3 | |
| May 6, 2012 at 9:42 | comment | added | user1822 | Your best (probably only) option is to restore your backups (which is standard the answer to a "pretty normal crash scenario") | |
| May 6, 2012 at 9:03 | history | edited | alfonx | CC BY-SA 3.0 |
added 312 characters in body
|
| May 6, 2012 at 8:39 | history | edited | alfonx | CC BY-SA 3.0 |
added 202 characters in body
|
| May 6, 2012 at 8:23 | history | asked | alfonx | CC BY-SA 3.0 |