Shell Programming and Scripting

#Alex Simpson
#Script to check the status of the Postgres DB

#function to check service status and restart
function FuncCheckService

{
	$ServiceName = 'pgsql-9.2'
	$arrService = Get-Service -Name $ServiceName

		if ($arrService.Status -eq 'Running')
     			{ 
         			Write-Output "$ServiceName service is running"
     			}
		else
   			  { 
        			 Write-Output "$ServiceName service is not running"
     			}
			}

#start transscript to log details
 Start-Transcript -Path "C:\Documents\CheckPostgresService.log" -Append -IncludeInvocationHeader

#Call function with EM service as a parameter
 FuncCheckService pgsql-9.2

#stop logging
 Stop-Transcript