Re: [HACKERS] Tablespaces

Merlin Moncure wrote:
> > I'm ruferring to NTFS and the win32 platforms. How does tar handle
> these
> > symlinks on the NTFS filesystem? What about if someone finds that
> FAT32
> > is significantly better for the database?
>
> FAT32 is not a journaling filesystem and has no security features and is
> not suitable for databases, period. Microsoft NT setup disks do not
> even allow FAT32 to be installed on disks over a certain size for the
> boot partition.
>
> PostgreSQL relies on standard features of the POSIX system, not on O/S
> attributes. AFAIK, win32 is the only non POSIX API supported by the
> PosgreSQL developers. If Microsoft's non POSIX compliance bothers you,
> install Interix, which provides POSIX for win32 (including symlinks).
> Or, use the linking option provided by the good folks who are doing the
> native port.

Symlinks have too many advantages on most platforms to use anything
else.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073