Re: [HACKERS] Tablespaces

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
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

In response to

Browse pgsql-hackers-win32 by date

  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