Difference between revisions of "Manually create PGSQL service"

From IMSMA Wiki

Jump to: navigation, search

Revision as of 20:27, 23 October 2014

	First verify that the service does not exist

Start the Command window / DOS prompt by e.g. search for cmd, right-click and choose Run as administrator.

Type cd.. until you are at C:\ (cd = change directory .. = one level up)
Type cd imsmang
Type cd pgsql
Type cd bin
Type pg_ctl register -N PGSQL -D "%IMSMA_HOME%\pgsql\data" and press Enter.
It is of cause possible to copy the text from here and paste it into the Command window by the right-click menu.
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.
DO NOT START THE SERVICE
Restart the computer (mandatory).
Verify that the PGSQL service was started automatically.

Technical

Implementation plan	IMSMA3 script changes 6.0

Data checks before upgrading	Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process

Upgrade process	Locale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing · Upgrade Category Error · Upgrade iReports to 6.0

Versions

MINT by topic	Administrating MINT · Creating Data Sources in MINT · Creating MINT Domains · Securing MINT Domains · Creating Ad Hoc Views in MINT · Creating Reports in MINT · Creating Dashboards in MINT · Creating Custom Home Pages in MINT · Customising MINT · Using MINT mobile · Using Jaspersoft Studio for MINT · Implementing drill-down in a dashboard · Useful online resources for MINT

MINT Implementation	MINT Implementation Checklist · MINT Examples and Exercises

MINT Admin	MINT Customised Files · Upgrade MINT Instructions · Pages used in A2

@@ Line 1: / Line 1: @@
 {{Note | First verify that the service does not exist }}
-# Start the Command window / DOS prompt by e.g. choosing Run, type '''cmd''' and click on OK.
+# Start the Command window / DOS prompt by e.g. search for ''cmd'', right-click and choose '''Run as administrator'''.<br/><br/>
 [[Image:Manually create service.png|500px|center]]
-# Type '''pg_ctl register -N PGSQL -D "%IMSMA_HOME%\pgsql\data"''' and press Enter.
+<br/>
+<ol start="2">
+<li> Type ''cd..'' until you are at '''C:\''' (cd = change directory .. = one level up)
+<li> Type ''cd imsmang''
+<li> Type ''cd pgsql''
+<li> Type ''cd bin''
+<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.
+<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.
+<li> '''DO NOT START THE SERVICE'''
+<li> Restart the computer ('''mandatory''').
+<li> Verify that the PGSQL service was started automatically.
+</ol>
 {{NavBox Hub}}
 [[Category:NoPublic]]
 [[Category:NAA]]