Install on windows - Revision history

WordpressAdmin69 at 15:03, 15 September 2021

2021-09-15T15:03:45Z

2020-04-03T11:20:04Z

2020-04-03T11:19:37Z

2020-04-03T11:18:19Z

2020-04-03T11:18:00Z

2020-04-03T09:40:16Z

2019-07-07T13:56:22Z

2019-05-25T16:50:51Z

2019-03-30T16:16:11Z

2019-03-29T14:21:04Z

@@ Line 60: / Line 60: @@
 * x.	Link the site up to the imported certificate and disable http in the bindings
 * y.	Add a dummy site on the http binding in c:\inetpub\itr_http which will redirect to the https site automatically. For example with the following html :
-* <!DOCTYPE html>
+<nowiki>* <!DOCTYPE html>
 * <html>
 *   <head>
 *     <meta http-equiv="Refresh" content="0; url=https://www.w3docs.com" />
 *   </head>
-* </html>
+* </html></nowiki>
+*
 .	Install required PIP packages

@@ Line 105: / Line 105: @@
   echo on
   ..\bin\pg_dumpall -h localhost -p 5432 -U postgres -v -f %BACKUP_FILE%
-Save this for example to a backup folder in the postgresql program folder and put this as a windows task. Name this script for example *backup.cmd*.
+Save this for example to a backup folder in the postgresql program folder and put this as a windows task. Name this script for example 'backup.cmd'.

@@ Line 90: / Line 90: @@
-If you would like to automate the backup of postgresql on windows a good script could be :
+If you would like to automate the backup of postgresql on windows a good starting point for a script could be :
   @echo off
   for /f "tokens=1-4 delims=/-. " %%i in ("%date%") do (
@@ Line 105: / Line 105: @@
   echo on
   ..\bin\pg_dumpall -h localhost -p 5432 -U postgres -v -f %BACKUP_FILE%

@@ Line 100: / Line 100: @@
   set datestr=%day%
   echo datestr is %datestr%
   set BACKUP_FILE=ITR_Daily_%datestr%.backup
   echo backup file name is %BACKUP_FILE%

← Older revision		Revision as of 11:18, 3 April 2020
Line 88:		Line 88:
	[[File:InstallWin10AppPool.png\|400px]]		[[File:InstallWin10AppPool.png\|400px]]
	Instead of administrator you would probably want to use another account with less permissions. For development servers Administrator is fine.		Instead of administrator you would probably want to use another account with less permissions. For development servers Administrator is fine.
		+
		+
		+	If you would like to automate the backup of postgresql on windows a good script could be :
		+	@echo off
		+	for /f "tokens=1-4 delims=/-. " %%i in ("%date%") do (
		+	set dow=%%i
		+	set month=%%j
		+	set day=%%k
		+	set year=%%l
		+	)
		+	set datestr=%day%
		+	echo datestr is %datestr%
		+
		+	set BACKUP_FILE=ITR_Daily_%datestr%.backup
		+	echo backup file name is %BACKUP_FILE%
		+	SET PGPASSWORD=ITR2018!
		+	echo on
		+	..\bin\pg_dumpall -h localhost -p 5432 -U postgres -v -f %BACKUP_FILE%

@@ Line 46: / Line 46: @@
 * j.	Add the files to the folder you want ( for example c:\inetpub\itr_site)
 * k.	In IIS click on the API folder in the site (You will have to do this for the external API as well)
-* l.	Rightclick – Convert to application. Set the right
+* l.	Rightclick – Convert to application. Set the right user for the application (and the associated application pool). The user should have the right to access the database and write to all ITR folders, start GIT (to retrieve the latest source code) and other service activities.
 * m.	Click Handler mappings
 * n.	Click Add module mapping

@@ Line 1: / Line 1: @@
 == Install ITR on a windows server or windows 10 version ==
-This installation assumes installing the ITR for development or other test purposes. It can be used as a starting point for installing a production server. Although in principe the ITR works on a Windows server we do not recommend using the ITR for production purposes on Windows systems using IIS. For production purposes we recommend a linux system like Ubuntu.
+This installation assumes installing the ITR for development or other test purposes. It can be used as a starting point for installing a production server.
 .	First install all latest windows updates so you windows system is as up to date as possible

@@ Line 4: / Line 4: @@
 .	First install all latest windows updates so you windows system is as up to date as possible
 .	Install postgresql 10.5 to c:\ disk
 * a.	Start the installation as default as possible