Version 25 (modified by pracine, 12 years ago) (diff)


=Initialize PostgreSQL cluster and run as server for compiled version =

This is still a work in progress 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) -- 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"

  5. Go into services panel under windows and start

    1. If your service does not start - check the Windows Event Viewer

    2. 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"

  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)

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}