Symlinking (specific) tables to different Drives - Mailing list pgsql-general

From Ow Mun Heng
Subject Symlinking (specific) tables to different Drives
Date
Msg-id 1188877895.28159.54.camel@neuromancer.home.net
Whole thread Raw
Responses Re: Symlinking (specific) tables to different Drives
List pgsql-general
Hi,

I'm running out of space on one of my partitions and I still have not
gotten all the data loaded yet. I've read that one could symlink the
pg_pg_xlog directory to another drive. I'm wondering if I can do the
same for specific tables as well.

Thanks.

I've already done a pg_dump of the entire schema but have not dropped /
re-init the DB to another location cos I'm afraid I'll lose some items.
(I've to drop the DB, format the partition, merge it w/ another
partition and re-init the DB then restore the DB from the dump)

sigh.. wish it was easier, (meaning, like SQL Server where one can
detach an entire DB/tablespace and then re-attach it elsewhere)

Anyway....
Thanks for the input.

pgsql-general by date:

Previous
From: Ow Mun Heng
Date:
Subject: Max File size per Table (1G limit??)
Next
From: "Mikko Partio"
Date:
Subject: Re: Symlinking (specific) tables to different Drives