postgresql提供了安裝文件（exe）和壓縮包文件（zip），有時我們希望在安裝完成后針對某些軟件做一些數據庫的初始化操作。所以有必要制作一個自己的postgresql安裝包。以下說一下nsis制作postgresql的注意事項。
1 官方下載postgresql壓縮包（zip），而非exe安裝包
2 下載nsis，nsis edit，ZIPDLL（用來解壓zip）
其它用代碼直接說明。
; Script generated by the HM NIS Edit Script Wizard.
; HM NIS Edit Wizard helper defines
!define PRODUCT_NAME "xtuple380"
!define PRODUCT_VERSION "1.0"
!define PRODUCT_PUBLISHER "seahouse"
!define PRODUCT_WEB_SITE "http://m.shnenglu.com/seahouse/"
!define PRODUCT_UNINST_KEY "Software\Microsoft\Windows\CurrentVersion\Uninstall\${PRODUCT_NAME}"
!define PRODUCT_UNINST_ROOT_KEY "HKLM"
; MUI 1.67 compatible ------
!include "MUI.nsh"
!include "ZipDLL.nsh"
; MUI Settings
!define MUI_ABORTWARNING
!define MUI_ICON "F:\xtuple\src\xtuple380\xtuple\guiclient\xTuple.ico"
!define MUI_UNICON "${NSISDIR}\Contrib\Graphics\Icons\modern-uninstall.ico"
; Welcome page
!insertmacro MUI_PAGE_WELCOME
; License page
!insertmacro MUI_PAGE_LICENSE "F:\infor\Dropbox\Dropbox\xTuple\docs\licence.txt"
; Components page
!insertmacro MUI_PAGE_COMPONENTS
; Directory page
!insertmacro MUI_PAGE_DIRECTORY
; Instfiles page
!insertmacro MUI_PAGE_INSTFILES
; Finish page
!insertmacro MUI_PAGE_FINISH
; Uninstaller pages
!insertmacro MUI_UNPAGE_INSTFILES
; Language files
!insertmacro MUI_LANGUAGE "SimpChinese"
; MUI end ------
Name "${PRODUCT_NAME} ${PRODUCT_VERSION}"
OutFile "xtuple-setup.exe"
InstallDir "$PROGRAMFILES\xtuple380"
ShowInstDetails show
ShowUnInstDetails show
Section "postgresql9.0.7" SEC01
SetOutPath "$INSTDIR"
SetOverwrite ifnewer
File "..\develop\postgresql-9.0.7-1-windows-binaries.zip"
File "F:\infor\Dropbox\Dropbox\xTuple\docs\installpackage\initdb.bat"
File "F:\infor\Dropbox\Dropbox\xTuple\docs\installpackage\pw.txt"
File "F:\infor\Dropbox\Dropbox\xTuple\docs\installpackage\uninstall.bat"
File "F:\infor\Dropbox\Dropbox\xTuple\docs\installpackage\userinit.bat"
File "F:\infor\Dropbox\Dropbox\xTuple\docs\installpackage\userinit.txt"
; ZipDLL::extractall "..\develop\postgresql-9.0.7-1-windows-binaries.zip" "c:\output"
; Use ZipDLL plugin
!insertmacro ZIPDLL_EXTRACT "$INSTDIR\postgresql-9.0.7-1-windows-binaries.zip" "$INSTDIR" "<ALL>"
Delete "$INSTDIR\postgresql-9.0.7-1-windows-binaries.zip"
; Set System env
ReadRegStr $0 HKLM "SYSTEM\CurrentControlSet\Control\Session Manager\Environment" "Path"
WriteRegExpandStr HKLM "SYSTEM\CurrentControlSet\Control\Session Manager\Environment" "Path" "$0;$INSTDIR\pgsql\bin"
; refresh env
SendMessage ${HWND_BROADCAST} ${WM_WININICHANGE} 0 "STR::Environment"
; init db by command line
; nsExec::ExecToLog 'cmd.exe pgsql\bin\initdb.exe -D pgsql\data -E UTF-8 --locale=chs -U postgres -W'
; nsExec::ExecToLog 'cmd.exe /c "$INSTDIR\pgsql\bin\httpd.exe" -D "$INSTDIR\pgsql\data" -E UTF-8 --locale=chs -U postgres -W'
; ExecWait 'commandpromt pgsql\bin\initdb.exe -D pgsql\data -E UTF-8 --locale=chs -U postgres -W'
ExecWait 'initdb.bat'
; ReadEnvStr $R0 COMSPEC
; nsExec::Exec 'commandpromt "$INSTDIR\pgsql\bin\initdb.exe" -D "$INSTDIR\pgsql\data" -E UTF-8 --locale=chs -U postgres -W'
; init user role and restore database from qucikstart
ExecWait 'userinit.bat'
SectionEnd
Section "xtuple380" SEC02
File "..\..\xTuple-3.8.0-Windows-release.zip"
; Use ZipDLL plugin
!insertmacro ZIPDLL_EXTRACT "$INSTDIR\xTuple-3.8.0-Windows-release.zip" "$INSTDIR" "<ALL>"
Delete "$INSTDIR\xTuple-3.8.0-Windows-release.zip"
; Set System env
ReadRegStr $0 HKLM "SYSTEM\CurrentControlSet\Control\Session Manager\Environment" "Path"
WriteRegExpandStr HKLM "SYSTEM\CurrentControlSet\Control\Session Manager\Environment" "Path" "$0;$INSTDIR\xTuple-3.8.0-Windows-release"
; refresh env
SendMessage ${HWND_BROADCAST} ${WM_WININICHANGE} 0 "STR::Environment"
SectionEnd
Section -AdditionalIcons
WriteIniStr "$INSTDIR\${PRODUCT_NAME}.url" "InternetShortcut" "URL" "${PRODUCT_WEB_SITE}"
CreateDirectory "$SMPROGRAMS\xtuple380"
CreateShortCut "$SMPROGRAMS\xtuple380\xtuple.lnk" "$INSTDIR\xTuple-3.8.0-Windows-release\xtuple.exe"
CreateShortCut "$SMPROGRAMS\xtuple380\pgAdmin3.lnk" "$INSTDIR\pgsql\bin\pgAdmin3.exe"
CreateShortCut "$SMPROGRAMS\xtuple380\Website.lnk" "$INSTDIR\${PRODUCT_NAME}.url"
CreateShortCut "$SMPROGRAMS\xtuple380\Uninstall.lnk" "$INSTDIR\uninst.exe"
; desktop shortcut
CreateShortCut "$desktop\xtuple.lnk" "$INSTDIR\xTuple-3.8.0-Windows-release\xtuple.exe"
SectionEnd
Section -Post
WriteUninstaller "$INSTDIR\uninst.exe"
WriteRegStr ${PRODUCT_UNINST_ROOT_KEY} "${PRODUCT_UNINST_KEY}" "DisplayName" "$(^Name)"
WriteRegStr ${PRODUCT_UNINST_ROOT_KEY} "${PRODUCT_UNINST_KEY}" "UninstallString" "$INSTDIR\uninst.exe"
WriteRegStr ${PRODUCT_UNINST_ROOT_KEY} "${PRODUCT_UNINST_KEY}" "DisplayVersion" "${PRODUCT_VERSION}"
WriteRegStr ${PRODUCT_UNINST_ROOT_KEY} "${PRODUCT_UNINST_KEY}" "URLInfoAbout" "${PRODUCT_WEB_SITE}"
WriteRegStr ${PRODUCT_UNINST_ROOT_KEY} "${PRODUCT_UNINST_KEY}" "Publisher" "${PRODUCT_PUBLISHER}"
SectionEnd
; Section descriptions
!insertmacro MUI_FUNCTION_DESCRIPTION_BEGIN
!insertmacro MUI_DESCRIPTION_TEXT ${SEC01} "數據庫服務組件。"
!insertmacro MUI_DESCRIPTION_TEXT ${SEC02} "客戶端軟件。"
!insertmacro MUI_FUNCTION_DESCRIPTION_END
Function un.onUninstSuccess
HideWindow
MessageBox MB_ICONINFORMATION|MB_OK "$(^Name) 已成功地從你的計算機移除。"
FunctionEnd
Function un.onInit
MessageBox MB_ICONQUESTION|MB_YESNO|MB_DEFBUTTON2 "你確實要完全移除 $(^Name) ，其及所有的組件？" IDYES +2
Abort
FunctionEnd
Section Uninstall
; etc uninstall system service
ExecWait 'uninstall.bat'
Delete "$INSTDIR\${PRODUCT_NAME}.url"
Delete "$INSTDIR\uninst.exe"
Delete "$SMPROGRAMS\xtuple380\xtuple.lnk"
Delete "$SMPROGRAMS\xtuple380\pgAdmin3.lnk"
Delete "$SMPROGRAMS\xtuple380\Uninstall.lnk"
Delete "$SMPROGRAMS\xtuple380\Website.lnk"
Delete "$desktop\xtuple.lnk"
RMDir "$SMPROGRAMS\xtuple380"
RMDir /r "$INSTDIR"
DeleteRegKey ${PRODUCT_UNINST_ROOT_KEY} "${PRODUCT_UNINST_KEY}"
SetAutoClose true
SectionEnd