Thread: BUG #1244: Postgres doesn't work on FAT

BUG #1244: Postgres doesn't work on FAT

From
"PostgreSQL Bugs List"
Date:
The following bug has been logged online:

Bug reference:      1244
Logged by:          Fernando del Valle

Email address:      delsat-sec@data54.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).

Re: BUG #1244: Postgres doesn't work on FAT

From
Harald Armin Massa
Date:
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@postgresql.org> wrote:
>=20
> The following bug has been logged online:
>=20
> Bug reference:      1244
> Logged by:          Fernando del Valle
>=20
> Email address:      delsat-sec@data54.com=20
>=20
> PostgreSQL version: 8.0 Beta
>=20
> Operating system:   Windows XP
>=20
> Description:        Postgres doesn't work on FAT
>=20
> Details:
>=20
> 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 filesyste=
m,
> 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 instal=
ler
> aborts. We have tested it with 7.5 devel and 8.0, and fails with both of
> them.
>=20
> BTW, the link to the bug reporter (this page) is not working (it should
> point to /bugform.html and not to /bugs/bugs.php).
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org )
>=20



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

Re: BUG #1244: Postgres doesn't work on FAT

From
Gaetano Mendola
Date:
Harald Armin Massa wrote:

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

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