Version 31 (modified by 15 years ago) ( diff ) | ,
---|
Initialize PostgreSQL cluster and run as server for compiled version
This is still a work in progress Back to windows compile
- Create a windows local user called postgres
- /c/postgres/bin/initdb -U postgres -D /c/postgres/data -A trust
- 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)
- Install as service: (From Dos not MingW) — note in this case postgres is a windows account and password you specified for the windows account.
"c:\postgres\bin\pg_ctl" register -N "pgsql-8.3 test" -D "C:\postgres\data" -U postgres -P "somepassword"
- Go into services panel under windows and start
- If your service does not start - check the Windows Event Viewer
- You can uninstall the service with:
"c:\postgres\bin\pg_ctl" unregister -N "pgsql-8.3 test" (this requires a restart)
A faster way is to stop the service and then from dos:
sc delete "pgsql-8.3 test"
- If your service does not start - check the Windows Event Viewer
- 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}
Note:
See TracWiki
for help on using the wiki.