Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers-win32 by date

Next:From: Andrew DunstanDate: 2004-03-04 21:05:00
Subject: Re: [HACKERS] Tablespaces
Previous:From: Merlin MoncureDate: 2004-03-04 20:24:21
Subject: Re: [HACKERS] Tablespaces

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group