KK'Pan

Version:
- xampp : xampp-win32-1.7.4-VC6.zip
  - PHP Version 5.3.5
  - Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8l
- PostgreSQL : postgresql-9.0.4-1-windows.exe
  (對於windows的portable安裝，設置步驟比較多，故暫不考慮)
- phpPgAdmin : phpPgAdmin-5.0.2.zip
下載並解壓縮xampp zip檔至root下。
跟installer檔差別在於如果不放置在根目錄底下(C:\ , D:\)，則要手動執行xampp_start.exe完成環境配置。
安裝PostgreSQL於"\xampp\pgsql"目錄底下(位置同MySQL的"\xampp\mysql")，安裝時會自動設置一windows user:postgres，並於安裝期間可指定其password。
下載phpPgAdmin的壓縮檔，decompress to "\xampp\phpPgAdmin"目錄底下(位置同phpMyAdmin的"\xampp\phpMyAdmin")。
修改"\xampp\apache\conf\httpd.conf"設定檔，加入以下此行讓apache載入postgresql的library(似乎是PHP的BUG!)。
```
Loadfile "%Your PostgreSQL installation directory%/bin/libpg.dll"
```
修改"\xampp\php\php.ini"的設定檔，開啟支援(unmark掉)
```
# default setting
# extension=php_pdo_pgsql.dll
# extension=php_pgsql.dll

extension=php_pdo_pgsql.dll
extension=php_pgsql.dll
```
修改"\xampp\phpPgAdmin\conf\config.inc.php"的php設定檔。
為了方便開發把以下登入的安全設定改為false來可以使用DB預設Admin登入。
```
//$conf['extra_login_security']=true;
$conf['extra_login_security']=false;
```

修改"\xampp\apache\conf\extra\httpd-xampp.conf"的apache用於xampp整合的specific settings。
可參考phpMyAdmin的配置來進行修改。


 Alias /phpmyadmin "xampp/phpMyAdmin/"
 
  AllowOvreride AuthConfig
 
 
 Alias /phppgadmin "xampp/phpPgAdmin/"
 
  AllowOvreride AuthConfig
  # 以下應該可不加，不過實際情況還是參考apache的configuration比較妥當。
  # 可參考最底下httpd.conf裡找到的片段說明。
  Order allow,deny
  Allow frrom all

加入安全訪問設定於LocationMatch中，在最後的server-info後面加入"|phppgadmin"。

#
# New XAMPP security concept
#

    Order deny,allow
    Deny from all
    Allow from 127.0.0.0/8 
    ErrorDocument 403 /error/HTTP_XAMPP_FORBIDDEN.html.var

開啟apache service開始使用xampp+postgresql+phppgadmin的windows的開發環境。

在httpd.conf裡找到Directory存取的描述

#
# DocumentRoot: The directory out of which you will serve your
# documents. By default, all requests are taken from this directory, but
# symbolic links and aliases may be used to point to other locations.
#
DocumentRoot "/xampp/htdocs"

#
# Each directory to which Apache has access can be configured with respect
# to which services and features are allowed and/or disabled in that
# directory (and its subdirectories). 
#
# First, we configure the "default" to be a very restrictive set of 
# features.  
#

    Options FollowSymLinks
    AllowOverride None
    Order deny,allow
    Deny from all


#
# Note that from this point forward you must specifically allow
# particular features to be enabled - so if something's not working as
# you might expect, make sure that you have specifically enabled it
# below.
#

#
# This should be changed to whatever you set DocumentRoot to.
#

    #
    # Possible values for the Options directive are "None", "All",
    # or any combination of:
    #   Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
    #
    # Note that "MultiViews" must be named *explicitly* --- "Options All"
    # doesn't give it to you.
    #
    # The Options directive is both complicated and important.  Please see
    # http://httpd.apache.org/docs/2.2/mod/core.html#options
    # for more information.
    #
    Options Indexes FollowSymLinks Includes ExecCGI

    #
    # AllowOverride controls what directives may be placed in .htaccess files.
    # It can be "All", "None", or any combination of the keywords:
    #   Options FileInfo AuthConfig Limit
    #
    AllowOverride All

    #
    # Controls who can get stuff from this server.
    #
    Order allow,deny
    Allow from all