Page 1 of 1

Initialise database cluster error

PostPosted: Tue Sep 02, 2008 7:05 pm
by Chumbita
Hi

When i am installing PostgreSQL i get this error The PostgreSQL must be on an NFTS formatted volume. This appears when i am on the "Initialise database cluster" step. What is it?
Ty

Re: Initialise database cluster error

PostPosted: Wed Sep 03, 2008 8:48 am
by WhiteRider
What operating system are you using?

Re: Initialise database cluster error

PostPosted: Wed Sep 03, 2008 3:59 pm
by Wazzzaaa10
I have the same problem.

my system is XP.

Re: Initialise database cluster error

PostPosted: Thu Sep 04, 2008 12:06 pm
by WhiteRider
Is your disk drive NTFS?
I would have thought that your disk drive would be NTFS - did you have an older operating system on this computer before?

Re: Initialise database cluster error

PostPosted: Thu Sep 04, 2008 1:18 pm
by kraada
This error is a result of having your hard drive formatted in an old (Pre-XP) fashion. You can either convert your filesystem to NTFS or install PostgreSQL on your system as is.

If you wish to install PostgreSQL on a non-NTFS filesystem, please restart the installation process, but uncheck "initialize database" when you see that checkbox. Installation should now finish normally. Once installation is complete, click Start --> Run, type in "cmd" and hit enter. At the command prompt type:
Code: Select all
cd "C:\Program Files\PostgreSQL\8.3\bin"

Note: Those quotes are necessary. Then hit enter. Then type:
Code: Select all
initdb -A trust -D "../data" -U postgres


Note: Those quotes are also necessary. Then hit enter. Close the command prompt when the command finishes, then click Start --> Programs --> PostgreSQL --> Stop Service followed by Start --> Programs --> PostgreSQL --> Start Service. PostgreSQL is now installed and should be running properly

If you wish to convert your filesystem to NTFS, backup any and all critical files. The conversion tool should be seamless, but in case of a power outage or other interruption in the process you may be unable to recover your system. You should back up any and all critical files before continuing. Click Start --> Run, hit enter, type "cmd" and hit enter again. This will bring up a command prompt. At the command prompt, type the following, where drive letter is the drive that you want to convert:
convert drive letter: /fs:ntfs

For example: convert E: /fs:ntfs

When prompted, enter a drive label (or name) for the drive. You may name the drive as you feel is appropriate. When the conversion is finished, exit the command prompt. You can now proceed to install PokerTracker 3 with PostgreSQL normally.

Re: Initialise database cluster error

PostPosted: Fri Sep 05, 2008 6:39 am
by Wazzzaaa10
I did that non-NTFS stuff and seems to be working now.

thanks