Re: About the requirements of security for W32.

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Alexander Panzhin" <whereabout(at)mail333(dot)com>
Cc: <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: About the requirements of security for W32.
Date: 2004-12-16 14:50:56
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3412A7570@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32


> I understand that security is very important, but does it really
matter
>
> when 1 person wants to test his own app on his own PC(witch is not
> connected to any Network).
> I can not test any of my app with PostgreSQL because it will not
install
> on my WinXP(No NTFS).
> It requests: NTFS, separate user and so on. Why?
> I have only 1 PC, I do not want to switch from FAT32(I would loose all
> my valuable data, and for compatibility with Linux) and in consequence
I
> cant test out PostgreSQL.
> You would say to hell with Win use Linux ,but there is a problem of
> testing Win apps on Linux.
> It would be great if there would be a command line switch that would
> overwrite some requiremnets(atleast for Win32 MSI Installer).

This has been discussed ad nauseum on the list but I'll summarize the
major points here:
1. You can run PostgreSQL on FAT32, but the installer will not allow it.
Fat32 is not journaling and should not host a database server.
2. The database runs as a user process so that if it is compromised your
machine will not be rooted (future versions of SQL server will do the
same).
3. PostgreSQL is open source. You can always disable the admin user
check and recompile (this is in fact a trivial edit). You need to
understand this if you are going to be developing applications for
PostgreSQL.
4. And most importantly, the MSI installer is *not* maintained as part
of the source distribution (all though the people involved are basically
all hackers). Go to pgfoundry to make requests and/or complaints about
it.

I promise that if you take the time to learn postgres and it's
internals, you will come to see the wisdom of these decisions, as I
have.

Merlin

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Andreas Pflug 2004-12-16 14:56:16 Re: About the requirements of security for
Previous Message Andrew Dunstan 2004-12-16 14:49:38 Re: About the requirements of security for