Difference between revisions of "Manually create PGSQL service"

From IMSMA Wiki
Jump to: navigation, search
Line 11: Line 11:
 
<li> Type ''cd bin'' and press Enter.
 
<li> Type ''cd bin'' and press Enter.
 
<li> Type ''pg_ctl register -N PGSQL -D "%IMSMA_HOME%\pgsql\data"'' and press Enter.<br/>
 
<li> Type ''pg_ctl register -N PGSQL -D "%IMSMA_HOME%\pgsql\data"'' and press Enter.<br/>
  It is of cause possible to copy the text from here and paste it into the Command window by the right-click menu.
+
  It is of course possible to copy the text from here and paste it into the Command window by the right-click menu.
 
<li> If there where no error messages, type Exit and press Enter.<br/>
 
<li> If there where no error messages, type Exit and press Enter.<br/>
 
  If there were error messages, one reason might be that the user does not have permission to create services or that you did '''not''' start the Command window as administrator.
 
  If there were error messages, one reason might be that the user does not have permission to create services or that you did '''not''' start the Command window as administrator.

Revision as of 21:38, 25 June 2016

Note.jpg First verify that the service does not exist
  1. Start the Command window / DOS prompt by e.g. search for cmd, right-click and choose Run as administrator.

Manually create service.png

  1. Type cd.. and press Enter until you are at C:\ (cd = change directory .. = one level up).
  2. Type cd imsmang and press Enter.
  3. Type cd pgsql and press Enter.
  4. Type cd bin and press Enter.
  5. Type pg_ctl register -N PGSQL -D "%IMSMA_HOME%\pgsql\data" and press Enter.
    It is of course possible to copy the text from here and paste it into the Command window by the right-click menu.
  6. If there where no error messages, type Exit and press Enter.
    If there were error messages, one reason might be that the user does not have permission to create services or that you did not start the Command window as administrator.
  7. DO NOT START THE SERVICE
  8. Restart the computer (mandatory).
  9. Verify that the PGSQL service was started automatically.
Note.jpg You need to be at the C-drive in the order to follow these instructions and if your Command window starts at another drive than C-drive then type C: to change to the C-drive.