Re: [GENERAL] Symlinking (specific) tables to different Drives

2007-09-05 Thread Ow Mun Heng
On Tue, 2007-09-04 at 07:49 +0300, Mikko Partio wrote: > > No (changing tablespaces does not change your logical schema). I just tested this "feature" with a temp table and it works as advertised. (In progress of moving a table there now actually) 2nd question.. reading the docs, it says that

Re: [GENERAL] Symlinking (specific) tables to different Drives

2007-09-03 Thread Mikko Partio
On 9/4/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote: > > On Tue, 2007-09-04 at 07:09 +0300, Mikko Partio wrote: > > > > > > On 9/4/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I'm running out of space on one of my partitions and I still > > have not > > go

Re: [GENERAL] Symlinking (specific) tables to different Drives

2007-09-03 Thread Ow Mun Heng
On Tue, 2007-09-04 at 07:09 +0300, Mikko Partio wrote: > > > On 9/4/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote: > 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 >

Re: [GENERAL] Symlinking (specific) tables to different Drives

2007-09-03 Thread Mikko Partio
On 9/4/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote: > > 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 table

[GENERAL] Symlinking (specific) tables to different Drives

2007-09-03 Thread Ow Mun Heng
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