| From: | Fernando Schapachnik <fernando(at)mecon(dot)gov(dot)ar> |
|---|---|
| To: | Greg Smith <greg(at)2ndquadrant(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Changing FS when full |
| Date: | 2010-01-22 12:50:52 |
| Message-ID: | 20100122125052.GA1571@bal740r0.mecon.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
En un mensaje anterior, Greg Smith escribió:
> >So, any way of instructing PG (8.1 if that matters) to place those
> >files elsewhere without an initdb?
> >
>
> You can create another table just like the original on a tablespace
> using the new storage, drop the original, and then rename the new one to
> the original name. This is described as "another way to cluster data"
> in the Notes section of
> http://www.postgresql.org/docs/8.4/static/sql-cluster.html , and it has
> a few warnings related to information that can be lost in this
> situation. Make sure you've moved all temporary files onto the new
> filesystem first, observing the warning about that there too.
One question: is this different from ALTER TABLE ... SET TABLESPACE?
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Millington | 2010-01-22 12:57:23 | Re: Error "invalid byte sequence for encoding UTF8" on insert into BYTEA column |
| Previous Message | Ivan Sergio Borgonovo | 2010-01-22 12:35:09 | Re: more docs on extending postgres in C |