Setting up a local Postgres development environment

1. Install Postgres

1. Download the installer from EnterpriseDB
2. Run the installer
3. Install Postgres into C:\xampp\pgsql{version_number} folder

2. Enable PostGres modules for PHP

1. Open php.ini file located in C:\xampp\php.
2. Uncomment the following lines in php.ini

   1 2	extension=php_pdo_pgsql.dll extension=php_pgsql.dll

3. Install Adminer

1. Download Adminer
2. Place the PHP file into HTDOCS

4. Wrapping up

1. Restart Apache
2. Adminer is now accessible here

Read Next

I’m running an experiment for better content recommendations. These are the 3 posts that are most likely to be interesting for you:

• How to install and optimize Apache with mpm_event, php5-fpm and MariaDB
  Unlock the full potential of your limited-resource server by mastering these LAMP stack optimization techniques, ensuring your web hosting is as efficient as possible.

• Blogging with Jupyter Notebooks in Hugo
  After mastering the integration of Postgres with XAMPP to enhance your local development setup, you might be intrigued by how I transformed my blogging workflow by embracing Jupyter notebooks, a move that could inspire you to streamline your own development and publishing processes.

• Get leads collected by a particular lead ad form between two timestamps using Facebook Graph API
  After mastering local development setup with Postgres and XAMPP, you might be eager to explore how to leverage APIs to enhance your projects, and this guide on fetching leads from Facebook using Python is a perfect next step!