How to Install PostgreSQL on XAMPP

1. Make sure you have XAMPP, PostgreSQL, and phppgadmin XAMPP has been installed as well.
2. Pgsql install it on XAMPP folder, for example C://xampp/pgsql
3. Extract and copy to your phpPgAdmin file C://xampp/ , So later in the directory C :/ / XAMPP folder is increased 2-pgsql and phpPgAdmin
4. Find the file C ://xampp/phpPgAdmin/conf/config.inc.php and edit this section

$conf['extra_login_security'] = true;
$conf['servers'][0]['host'] = ” “;
be
$conf['extra_login_security'] = false;
$conf['servers'][0]['host'] = ‘localhost’;

still in the same file, change to change its path so pg_dump

$conf['servers'][0]['pg_dump_path'] = ‘C:/xampp/pgsql/9.0/bin/pg_dump’;
$conf['servers'][0]['pg_dumpall_path'] = ‘C:/xampp/pgsql/9.0/bin/pg_dump’;

For our purposes is to export or import the database
5. Search for files C://xampp/php/php.ini,then find the line

“;extension=php_pgsql.dll”
remove the sign ‘;’
so the results are so
“extension=php_pgsql.dll“

6. Open file C://xampp/apache/conf/extra/httpd-xampp.conf, do not forget to back up beforehand. Add the below lines of code in the module alias:

Alias /phppgadmin “C:/xampp/phpPgAdmin/”
<Directory “C:/xampp/phpPgAdmin”>
AllowOverride AuthConfig
Order allow,deny
Allow from all
</Directory>

7. Install phase has been completed, for then we try to address in the browser
http://localhost/phppgadmin