Re: Temporary files directory

On Tue, Jan 23, 2001 at 11:38:55AM -0500, Tom Lane wrote:
> > Additionally, is it possible to create a database than spans on more than
> > one partition or harddisk under Linux ?
>
> Right now, the only way to do this is to manually move individual files
> around and then establish symlinks to them from where they were in the
> database directory. While this works, it's pretty darn tedious to
> maintain, especially for large tables that might contain many segments;
> and you more or less have to shut down the database while moving files
> around, too. We have plans to create a more useful "tablespace"
> administration capability in the future.
>
> What I'd recommend in the short term is that you use a filesystem
> implementation that allows a logical filesystem to span multiple
> physical disks. My preferred OS, HPUX, can do this easily; I believe
> the same thing can be done with some Linux filesystems but don't know
> the details. (Any help out there?)

It's not really a filesystem issue, but a volume-manager issue.
On linux you can use LVM or md to create devices that span multiple
disks. With LVM you can even add more disks and grow your devices
without stoping your databases! :-)

--
Ragnar Kjørstad
Big Storage