Re: [ADMIN] lost tablespace

2011-11-10 Thread Craig Ringer
It'd help to know what Pg version you're running. Comments inline below. On 11/10/2011 07:01 PM, Thorsten Strufe wrote: sorry, noob here. So we've just started using postgre and right at the start we had a hardware problem with a hard drive failing. We can still start postgre but a tablespace f

Re: [ADMIN] lost tablespace

2011-11-10 Thread Kevin Grittner
Thorsten Strufe wrote: > is there any (sane) way to simply get postgre to entirely forget > about the broken db - and that's it (dumping the other db and > loading it back might not be the best solution, since it's rather > large..)? I think that using pg_dump for the good databases is sane, a

[ADMIN] lost tablespace

2011-11-10 Thread Thorsten Strufe
Hi everybody, sorry, noob here. So we've just started using postgre and right at the start we had a hardware problem with a hard drive failing. We can still start postgre but a tablespace for a db that we don't even need anymore is lost. Now we would think that shouldn't be a problem, we could sim