The following bug has been logged online:

Bug reference: 1244
Logged by: Fernando del Valle

Email address: delsat-sec (AT) data54 (DOT) com

PostgreSQL version: 8.0 Beta

Operating system: Windows XP

Description: Postgres doesn't work on FAT

Details:

Postgres installs fine on W2K + FAT32, but not on Windows XP + FAT32. The
difference seems to be in CACLS.EXE, which is used by the installer to
change the permissions of files. When used on a file in a FAT32 filesystem,
in Windows 2000, CACLS.EXE returns ok (even though it does not perform the
operation, as it can't). On XP, CACLS.EXE returns an error and the installer
aborts. We have tested it with 7.5 devel and 8.0, and fails with both of
them.

BTW, the link to the bug reporter (this page) is not working (it should
point to /bugform.html and not to /bugs/bugs.php).



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Hello,

in the release notes there is a "FAT is not really supported" notice
for PostgreSQL.

I suggest following workaround:

create a cacls.exe and put it first in the search path. That cacls.exe
should just return "OK" no matter of the imput-params.


Be warned that "FAT is not really supported" has good reasons.

Harald



On Tue, 7 Sep 2004 16:21:58 +0100 (BST), PostgreSQL Bugs List
<pgsql-bugs (AT) postgresql (DOT) org> wrote:


--=20
GHUM Harald Massa
Harald Armin Massa
Reinsburgstra=DFe 202b
70197 Stuttgart
0173/9409607

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Harald Armin Massa wrote:

I think that we have to decide if postgres is supposed to work on
FAT32 or not. If, as I expect, the response is not, then we have to find
a relaiable way to detect a NTFS ( also when a tablespace is created BTW )
and refuse to start on a FATXX, and not trust on the failre of a cacls.exe

My 2 cents.

Regards
Gaetano Mendola





---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match