Changes between Version 24 and Version 25 of UsersWikiWinCompileInitdb


Ignore:
Timestamp:
Dec 9, 2009, 7:05:24 AM (14 years ago)
Author:
pracine
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • UsersWikiWinCompileInitdb

    v24 v25  
    1 '''===Initialize PostgreSQL cluster and run as server for compiled version ==='''
     1=Initialize PostgreSQL cluster and run as server for compiled version =
    22
    33'''This is still a work in progress ''' [UsersWikiWinCompile Back to windows compile]
    44
    55
    6   1. Create a windows local user called postgres
    7   2. /c/postgres/bin/initdb -U postgres -D /c/postgres/data -A trust
    8   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)
    9   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.
    10 
    11 "c:\postgres\bin\pg_ctl" register -N "pgsql-8.3 test" -D "C:\postgres\data" -U postgres -P "somepassword"
    12   5. go into services panel under windows and start 
    13 a. If your service does not start - check the Windows Event Viewer
    14 
    15 b. You can uninstall the service with:
    16 
    17 "c:\postgres\bin\pg_ctl" unregister -N "pgsql-8.3 test" (this requires a restart)
    18 
    19 A faster way: stop the service and then from dos
    20 
    21 sc delete "pgsql-8.3 test"
    22 
    23 
    24 6. Before you do a make check for PostGIS
     6 1. Create a windows local user called postgres
     7 1. /c/postgres/bin/initdb -U postgres -D /c/postgres/data -A trust
     8 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)
     9 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]]
     10 1. Go into services panel under windows and start[[BR]][[BR]]
     11  a. If your service does not start - check the Windows Event Viewer[[BR]][[BR]]
     12  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]]
     13sc delete "pgsql-8.3 test"[[BR]][[BR]]
     14 1. Before you do a make check for PostGIS
    2515-- make sure to do an export of PGPORT and other variable to point to the one you are testing (this you do in Msys)
    2616http://www.postgresql.org/docs/8.3/interactive/libpq-envars.html