robust way of moving tables to a different disk??

From: Sam Mortimer <samm(at)netservicesplc(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: robust way of moving tables to a different disk??
Date: 2004-12-15 15:40:41
Message-ID: 99795FEF570BA64EA0FA6D4540FBB04001191C04@NETEXCH02
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2004-12-15 16:01:11 [Fwd: Majordomo results: unsubscribe]
Previous Message Wang Jun 2004-12-15 12:42:17 [Re]:User Admin in pgsql