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 99795FEF570BA64EA0FA6D4540FBB04001191C04@NETEXCH02
Whole thread Raw
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: Haiyan He
Date:
Subject: Postgres SQL & BlueDragon ColdFusion on OS X Server
Next
From: Andrew Sullivan
Date:
Subject: Re: Tyan Thunder MB for postgres server