Edit C:\Program Files (x86)\PostgreSQL\9.5\installer\server\loadmodules.vbs
' Copyright (c) 2012-2016, EnterpriseDB Corporation. All rights reserved On Error Resume Next ' PostgreSQL server module load script for Windows Const ForReading = 1 Const ForWriting = 2 ' Check the command line If WScript.Arguments.Count <> 5 Then Wscript.Echo "Usage: loadmodules.vbs <Username> <Password> <Install dir> <Data dir> <Port>" Wscript.Quit 127 End If strUsername = WScript.Arguments.Item(0) strPassword = WScript.Arguments.Item(1) strInstallDir = WScript.Arguments.Item(2) strDataDir = WScript.Arguments.Item(3) iPort = WScript.Arguments.Item(4) Dim regExp, objShell, objFso, objTempFolder 'Escape the '%' as '%%', if present in the password Set regExp = new regexp regExp.Pattern = "[%]" strFormattedPassword = regExp.Replace(strPassword, "%%") iWarn = 0 ' Get a temporary filenames Set objShell = WScript.CreateObject("WScript.Shell") Set objFso = CreateObject("Scripting.FileSystemObject") Set objTempFolder = objFso.GetSpecialFolder(2) strBatchFile = Replace(objFso.GetTempName, ".tmp", ".bat") strOutputFile = objTempFolder.Path & "\" & objFso.GetTempName ' Execute a command. Note that we use Shell.Run here to prevent spawning DOS boxes. ' Unfortunately that means we have to hack things about to get the command output Function DoCmd(strCmd) Dim objBatchFile Set objBatchFile = objTempFolder.CreateTextFile(strBatchFile, True) objBatchFile.WriteLine "@ECHO OFF" objBatchFile.WriteLine "CHCP " & objShell.RegRead("HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage\ACP") objBatchFile.WriteLine "SET PGPASSWORD=" & strFormattedPassword objBatchFile.WriteLine strCmd & " > """ & strOutputFile & """ 2>&1" objBatchFile.WriteLine "SET PGPASSWORD=" objBatchFile.WriteLine "EXIT /B %ERRORLEVEL%" objBatchFile.Close WScript.Echo " Executing '" & objTempFolder.Path & "\" & strBatchFile & "'..." DoCmd = objShell.Run(objTempFolder.Path & "\" & strBatchFile, 0, True) If objFso.FileExists(objTempFolder.Path & "\" & strBatchFile) = True Then objFso.DeleteFile objTempFolder.Path & "\" & strBatchFile, True End If If objFso.FileExists(strOutputFile) = True Then Set objOutputFile = objFso.OpenTextFile(strOutputFile, ForReading) WScript.Echo objOutputFile.ReadAll objOutputFile.Close objFso.DeleteFile strOutputFile, True Else WScript.Echo " Couldn't find the output file..." End If End Function Sub Warn(msg) WScript.Echo msg iWarn = 2 End Sub ' Install adminpack in the postgres database WScript.Echo "Installing the adminpack module in the postgres database..." iRet = DoCmd("""" & strInstallDir & "\bin\psql.exe"" -p " & iPort & " -U " & strUsername & " -c ""CREATE EXTENSION adminpack;"" postgres") if iRet <> 0 Then warn "Failed to install the 'adminpack' module in the 'postgres' database" ' All done!! WScript.Echo "loadmodules.vbs ran to completion" WScript.Quit iWarn
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de