I've always had problems installing PostgreSQL, here's what I did with the initdb:1 errors:
First uninstall PostgreSQL, and remove the postgres user account by clicking start -> run and copy pasting the following command and clicking ok:
net user postgres /delete
Log in as administrator and follow
this guide, except UNCHECK initialise database cluster. Won't give initdb errors now. After that, go to c:\program files\PostgreSQL\8.3\, right click "data" folder and select properties. Go to the security tab, select user "postgres" and check "allow full control". Do the same for "Users" user. Click apply&ok.
Click start -> run, copy paste the following line and click ok:
"c:\program files\postgresql\8.3\bin\initdb.exe" -D "c:\program files\postgresql\8.3\data"
Reboot. Go to start\program files\postgresql 8.3\ and launch pgadmin III, try to connect to the database. If you can't connect, you probably have to edit the config files. Go to start\program files\postgresql 8.3\configuration files and edit postgresql.conf. Search for "listen_addresses" and change the value from 'localhost' to '*'. While you're at it, you might want to edit pg_hba.conf, scroll to the bottom and change METHOD values from "MD5" to "trust". Look in the postgresql\8.3\data folder and delete postmaster.pid file if there is one. Restart the postgresql service, and try connecting again.
You might also have to install postgresql odbc driver, download the latest version from
here
After installation you can remove the full control rights to the data folder.
Disclaimer: I don't now anything about PostgreSQL and half the instructions here might be redundant or just plain wrong, but it worked for me. I also don't have Vista so installing on it might be a whole different game.
If this doesn't work, too bad!
Last edited by Lateksi; 02-29-2008 at 04:29 PM.