From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com> |
Cc: | tswan(at)idigx(dot)com, PostgreSQL Win32 port list <pgsql-hackers-win32(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Tablespaces |
Date: | 2004-03-04 20:29:26 |
Message-ID: | 200403042029.i24KTQV09569@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2004-03-04 21:05:00 | Re: [HACKERS] Tablespaces |
Previous Message | Merlin Moncure | 2004-03-04 20:24:21 | Re: [HACKERS] Tablespaces |