'''===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 2. /c/postgres/bin/initdb -U postgres -D /c/postgres/data -A trust 3. 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) 4. Install as service: (From Dos not MingW) "c:\postgres\bin\pg_ctl" register -N "pgsql-8.3 test" -D "C:\postgres\data" -U postgres -P "somepassword" 5. go into services panel under windows and start a. If your service does not start - check the Windows Event Viewer b. You can uninstall the service with: "c:\postgres\bin\pg_ctl" unregister -N "pgsql-8.3 test" (this requires a restart) A faster way: stop the service and then from dos sc delete "pgsql-8.3 test" 6. 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}