| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Morus Walter <morus(dot)walter(at)tanto(dot)de> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: when datas filesystem is full how to do |
| Date: | 2005-02-16 15:24:52 |
| Message-ID: | 24113.1108567492@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Morus Walter <morus(dot)walter(at)tanto(dot)de> writes:
> I guess the problem is, that he doesn't want to stop the database.
Yeah ... I'm afraid that's an impractical goal.
> I'd rather suggest to look into tablespaces.
> Create a new tablespace on some other filesystem and move the contents
> of the database by using ALTER TABLE/INDEX SET TABLESPACE...
Although the postmaster may stay up, this would still involve taking
exclusive locks on large tables for long enough to copy them to another
disk. That would probably knock out his application just as effectively
as a full database shutdown. And of course it's not even an option
unless he's running PG 8.0.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-02-16 15:37:14 | Re: WHat foldsers in the data folder would I need to link to have my data on a different drive? |
| Previous Message | Joel Fradkin | 2005-02-16 14:56:49 | WHat foldsers in the data folder would I need to link to have my data on a different drive? |