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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
