Search Postgresql Archives

Re: ntfs for windows port rc5-2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You may wish to consider a different database for your project. SQLite may be a better choice, for example, depending on the project's specific needs (www.sqlite.org).

Win95/98/ME is poor technology, no matter how many users it still has. It's probably about time for them to upgrade or switch to another OS (of course, I think Windows in general is a poor technology, but that's for another list...).

OTOH, does anyone know if the cygwin version of postgresql enforces the NTFS requirement? That may be another option...


On Jan 14, 2005, at 4:39 PM, J. Greenlees wrote:

Martijn van Oosterhout wrote:
On Fri, Jan 14, 2005 at 08:39:28AM -0800, J. Greenlees wrote:
why?
since an app that I'm working on would be useless for 60% of potential clients, using posgresql with the requirement for ms' corrupted ntfs means postgresql isn't going to work for it.
I think what you are referring to is the installer refusing to install
on a NTFS partition. From the FAQ:
http://pginstaller.projects.postgresql.org/FAQ_windows.html
2.4) Can I install PostgreSQL on a FAT partition?
PostgreSQL's number one priority is the integrity of your data. FAT and
FAT32 filesystems simply do not offer the reliabilty required to allow
this. In addition, the lack of security features offered by FAT make it
impossible to secure the raw data files from unauthorised modification.
Finally, PostgreSQL utilises a feature called 'reparse points' to
implement tablespaces. This feature is not available on FAT partitions.
<snip>
It is recognised however, that on some systems such as developer's PCs,
FAT partitions may be the only choice. In such cases, you can simply
install PostgreSQL as normal, but without initialising the database
cluster. When the installation has finished, manually run the
'initdb.exe' program on the FAT partition. Security and reliability
will be compromised however, and any attempts to create tablespaces
will fail.
since ms does not include a compiler, and the source for 8.0 won't cross compile from linux. ( gcc 3.3.0 )
To compile the native port on Windows you need MinGW. And there's
always the Cygwin port still. See:
http://www.postgresql.org/files/documentation/faqs/text/FAQ_MINGW
Hope this helps,
rc5-2 msi will not install at all on a fat32 filesystem
even without initialising the database.
sorry but whole purpose of putting it on a windows box was to make db app for a 250,000 person client base.
with some still using win95, some win 98, some winme.
all of which do not have ntfs support.


since the app will not be world accessable, only through localhost, the lack of security isn't a major concern.

--
========================================

only plain text format email accepted.

smaller file size, no virus transfer
no proprietary file formats.

========================================

- -----------------------------------------------------------
Frank D. Engel, Jr.  <fde101@xxxxxxxxxxx>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)


iD8DBQFB6EOs7aqtWrR9cZoRAtGcAKCDdfxAWPzNw23+hJ/t9xObxoP+kACfTz1T
eD6NOkOnIcok1U3iSGnjxyo=
=P26l
-----END PGP SIGNATURE-----



___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com


---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux