Re: Table Spaces

Thomas Hallgren wrote:

>"Manfred Spraul" <manfred(at)colorfullife(dot)com> wrote in message
>news:40A8EEE9(dot)3000405(at)colorfullife(dot)com(dot)(dot)(dot)
>
>
>>Bruce Momjian wrote:
>>
>>
>>
>>>The only downside to removal is that folks without symlinks (I believe
>>>Win32 only) will loose that functionality with nothing to replace it.
>>>However, I think the clarity of removing it is worth it. Also, I think
>>>someone had a special way to do symlinks on Win32 and we should look
>>>into that.
>>>
>>>
>>>
>>>
>>Windows 2000 and later support mount points - you can attach a new
>>partition as C:\pgsql\data\xlog instead of D:\. That might be enough for
>>most users. IIRC there was a tool to create arbitrary links, but it was
>>removed just before W2K final.
>>
>>
>>
>If you run NTFS, it's still possible to use arbitrary links. In the Windows
>world, they are called junctions. Microsoft does not provide a junction tool
>for some reason (perhaps because it's limited to NTFS). A good tool, free
>and with source, can be found here
>http://www.sysinternals.com/ntw2k/source/misc.shtml#junction I use this tool
>myself. Works like a charm.
>
>
>

We've looked at it before. Apart from anything else I don't think its
license is compatible with PostgreSQL's.

Also, IIRC NTFS junctions also have some severe limitations.

cheers

andrew