Edit

Manually create PGSQL service

Revision as of 19:08, 23 October 2014 by Alnaucler (talk | contribs) (Created page with "{{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. Image:Manually creat...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

	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.

Type pg_ctl register -N PGSQL -D "%IMSMA_HOME%\pgsql\data" and press Enter.

Technical Notes Portal

Hub

Check Database

Check attachments · Check coordinates distance and bearing · Check geospatial orphans · Check Link Table Deleted · Check link table approval_state NEW · Check link orphans 6.0 · Fieldreport ID and Dates · Missing Approval information PGSQL · Missing Date of Information PGSQL · Missing Local ID PGSQL

Technical

CDF error NullPointerException · Change CDF data type · How to install ArcEngine 10.1 with higher version of ArcGIS · How to revert to ArcEngine 9.3.1 · IMSMA3 script writing · Old Permission Group · Optimizing views in pgSQL · pgSQL Replication · Sortorder enumeration values · Technical Support Documents · Update imsma user

Upgrade Process

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

List 6.0 Versions · List 6.0 Bug Fixed Version

MINT

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

Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Manually_create_PGSQL_service&oldid=17307"