=Initialize PostgreSQL cluster and run as server for compiled version = '''This is still a work in progress ''' [UsersWikiWinCompile Back to windows compile] 1. Create a windows local user called postgres 1. /c/postgres/bin/initdb -U postgres -D /c/postgres/data -A trust 1. you may want to change the port in the C:/postgres/data/posgresql.conf file (in our case running under 8433 not to conflict with our regular postgres install) 1. Install as service: (From Dos not MingW) -- note in this case postgres is a windows account and password you specified for the windows account.[[BR]][[BR]] "c:\postgres\bin\pg_ctl" register -N "pgsql-8.3 test" -D "C:\postgres\data" -U postgres -P "somepassword"[[BR]][[BR]] 1. Go into services panel under windows and start[[BR]][[BR]] a. If your service does not start - check the Windows Event Viewer[[BR]][[BR]] a. You can uninstall the service with:[[BR]][[BR]] "c:\postgres\bin\pg_ctl" unregister -N "pgsql-8.3 test" (this requires a restart)[[BR]][[BR]]A faster way is to stop the service and then from dos:[[BR]][[BR]] sc delete "pgsql-8.3 test"[[BR]][[BR]] 1. Before you do a make check for PostGIS -- make sure to do an export of PGPORT and other variable to point to the one you are testing (this you do in Msys) http://www.postgresql.org/docs/8.3/interactive/libpq-envars.html These are only good for current session export PATH="/c/postgres/bin:$PATH" export PGPORT=8433 export PGUSER=postgres to see path settings or any other variables at msys prompt echo ${PATH}