Difference between revisions of "Manually create PGSQL service"

From IMSMA Wiki

Jump to: navigation, search

Revision as of 10:18, 18 July 2015

	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.. and press Enter until you are at C:\ (cd = change directory .. = one level up).
Type cd imsmang and press Enter.
Type cd pgsql and press Enter.
Type cd bin and press Enter.
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 or that you did not start the Command window as administrator.
DO NOT START THE SERVICE
Restart the computer (mandatory).
Verify that the PGSQL service was started automatically.

	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.

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 6: / Line 6: @@
 <br/>
 <ol start="2">
-<li> Type ''cd..'' until you are at '''C:\''' (cd = change directory .. = one level up)
+<li> Type ''cd..'' and press Enter until you are at '''C:\''' (cd = change directory .. = one level up).
-<li> Type ''cd imsmang''
+<li> Type ''cd imsmang'' and press Enter.
-<li> Type ''cd pgsql''
+<li> Type ''cd pgsql'' and press Enter.
-<li> Type ''cd bin''
+<li> Type ''cd bin'' and press Enter.
 <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.