title: Connecting cakephp 2.0 with PostgreSQL
body: <p>I am using cakephp 2.0 and a wamp server. I have enabled the pdo of postgres in the php and i tried connecting to Postgres. However it still says that there is an error. My login and password is also double confirmed.</p>
  
  <p>Below is codes for the database.php file:</p>
  
  <pre><code>public $default = array(
    'datasource' =&gt; 'Database/Postgres',
    'persistent' =&gt; false,
    'host' =&gt; 'localhost',
    'port' =&gt; '5432',
    'login' =&gt; 'postgres',
    'password' =&gt; 'password',
    'database' =&gt; 'Test',
    'schema' =&gt; '',
    'prefix' =&gt; '',
    'encoding' =&gt; ''
   );
  </code></pre>
  
  <p>I even tried this:</p>
  
  <pre>
  public $default = array(
      'datasource' => 'Database/Postgres',
      'persistent' => false,
      'host' => 'localhost',
      'port' => '5432',
      'login' => 'postgres',
      'password' => 'password',
      'database' => 'Test',
      'schema' => 'public',
      'prefix' => '',
      'encoding' => ''
    );</pre>
  
  <p>My pga_hba.config file is:</p>
  
  <pre>
   TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
  
  # IPv4 local connections:
  host    all         all         127.0.0.1/32          md5
  # IPv6 local connections:
  host    all         all         ::1/128               md5
  </pre>
  
  <p>In the C:\wamp\bin\php\php5.3.9\ext</p>
  
  <p>I have both:</p>
  
  <pre>
  php_pdo_pgsql.dll
  php_pdo_sqlite.dll
  </pre>
  
  <p>My config Postgres config file is :</p>
  
  <pre>
  listen_addresses = '*'      # what IP address(es) to listen on;
                      # comma-separated list of addresses;
                      # defaults to 'localhost', '*' = all
                      # (change requires restart)
  port = 5432             # (change requires restart)
  max_connections = 100           # (change requires restart)
  # Note:  Increasing max_connections costs ~400 bytes of shared memory per 
  # connection slot, plus lock space (see max_locks_per_transaction).
  #superuser_reserved_connections = 3 # (change requires restart)
  #unix_socket_directory = ''     # (change requires restart)
  #unix_socket_group = ''         # (change requires restart)
  #unix_socket_permissions = 0777     # begin with 0 to use octal notation
                      # (change requires restart)
  #bonjour_name = ''          # defaults to the computer name
                      # (change requires restart)
  </pre>
  
  <p>I check php info and I still found that that the pgsql was not there. I am using wamp server. </p>
  
  <pre>
  [PostgresSQL]
  ; Allow or prevent persistent links.
  ; http://php.net/pgsql.allow-persistent
  pgsql.allow_persistent = On
  
  ; Detect broken persistent links always with pg_pconnect().
  ; Auto reset feature requires a little overheads.
  ; http://php.net/pgsql.auto-reset-persistent
  pgsql.auto_reset_persistent = Off
  
  ; Maximum number of persistent links.  -1 means no limit.
  ; http://php.net/pgsql.max-persistent
  pgsql.max_persistent = -1
  
  ; Maximum number of links (persistent+non persistent).  -1 means no limit.
  ; http://php.net/pgsql.max-links
  pgsql.max_links = -1
  
  ; Ignore PostgreSQL backends Notice message or not.
  ; Notice message logging require a little overheads.
  ; http://php.net/pgsql.ignore-notice
  pgsql.ignore_notice = 0
  
  ; Log PostgreSQL backends Noitce message or not.
  ; Unless pgsql.ignore_notice=0, module cannot log notice message.
  ; http://php.net/pgsql.log-notice
  pgsql.log_notice = 0
  </pre>
  
  <p>I already did this in my php.ini file:</p>
  
  <pre>
  extension=php_pdo_pgsql.dll
  extension=php_pdo_sqlite.dll
  extension=php_pgsql.dll
  </pre>