robust way of moving tables to a different disk?? - Mailing list pgsql-admin

From Sam Mortimer
Subject robust way of moving tables to a different disk??
Date
Msg-id e0992c5504121602064851bc7@mail.gmail.com
Whole thread Raw
Responses Re: robust way of moving tables to a different disk??  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hello,

I'd like to move some tables from a particular database onto a
different set of disks.  However, I can't see any robust way of
achieving this.  I've tried using symlinks but these can easily be
broken by a mixture of "vacuum full" and growing the table again
(assuming the table is large enough to span multiple files).  We can
handle a solution that breaks when the table is dropped and recreated,
that's a special enough case enough to be managed.

Any ideas welcome!

Regards,
-Sam.

pgsql-admin by date:

Previous
From: "Iain"
Date:
Subject: easy one: location of the database cluster
Next
From: CRI74 - Fabien Combernous
Date:
Subject: CREATE USER ...