Select Page

How to setup PostgreSQL on WAMP server

  1. Ensure that PostgreSQL has been installed on your machine. The Windows installers can be downloaded from http://www.postgresql.org/download/windows/
  2. Assuming WAMP Server is installed on c:\wamp, copy C:\wamp\bin\php\php5.4.3\libpq.dll to C:\wamp\bin\apache\apache2.4.2\bin\libpq.dll
  3. Also see that the following files exist
    • C:\wamp\bin\php\php5.4.3\ext\php_pgsql.dll
    • C:\wamp\bin\php\php5.4.3\ext\php_pdo_pgsql.dll
  4. The above two files are PHP extensions and should be enabled using the WAMP menu or the php.ini file

Related Articles

Last Updated On September 06, 2018

2 Comments

  1. Saaid Agherdien

    where should i install postgressql for setting it up on wamp64 server. Can it be on c:/Program files or must it be on C:\wamp64\bin

    Reply
    • Ian Carnaghan

      It shouldn’t matter where you have postgres physically installed on your system. so long as the server is up and running and you make the necessary modifications in WAMP.

      Reply

Leave a reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.