Postgresql Download Problems

[Neeranam]

In the wizard setup I get to the last part("Initialis Database Cluster" step) then:-

It says -"the postgreSQL data directory must be on a NTFS formatted volume"

"If you wish to install the data directory on another type of partition(which is not recomended, and is unsupported) you must initialise the database cluster manually by running initdb.exe."

Can any of you experts translate this into English

[malcolmswaine]

It sounds like it wants to put the data and transaction logs onto a file system that is formatted with NTFS, as opposed to FAT32, which I'm assuming is where the problems is.

Check the file system format on the drive you're setting the data directory to (right click drive letter in explorer, properties).

If this is indeed the case, either convert the drive to NTFS or choose another drive thats already NTFS formatted (assuming you've got one)

PM me if you're stuck.

[niller74]

As Malcom write, this is due to PostgreSQL require NTFS support as opposed to the older FAT and FAT32 filesystems.

If you ran your PostgreSQL on a Linux box you would be fine

I believe there is a tiny tool that will build a virtual NTFS partition on your FAT32 one. This will be slower, but if you are just using it for development or testing you should be fine.

Google for virtual NTFS

[Neeranam]

It sounds like it wants to put the data and transaction logs onto a file system that is formatted with NTFS, as opposed to FAT32, which I'm assuming is where the problems is.

Check the file system format on the drive you're setting the data directory to (right click drive letter in explorer, properties).

If this is indeed the case, either convert the drive to NTFS or choose another drive thats already NTFS formatted (assuming you've got one)

PM me if you're stuck.

Thanks. I se my D drive is NTFS, I;ll give it a go again.