Configure PostgreSQL and phpPgAdmin in WAMP
As i told earlier am trying to switch to Flex , i am trying to learn connection between PHP and Flex. When searched i got a excellent tutorial . But the problem is that it uses PostgreSQL. As i don't have any prior experience in PostgreSQL i try to install it in my Windows 7 and configure it in WAMP . I got different errors and spend almost two days in searching and using different methods . Atlast i got it right. I will try to figure out the steps i have done.
Am using
Install WAMP server where ever you need.
Download PhpPgAdmin and unzip it to WWW folder in WAMP installation.
At this point if you try to access the http://localhost/phpPgAdmin/ you may get this error.
Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option.
This is because you need to enable two extensions.
Now try this http://localhost/phpPgAdmin/ and you will see the PostgreSQL server. Select the PostgreSQL and login using the deafult user "postgres" and the password you given when PostgreSQL installed. You may not able to login. It may say "Login disallowed for security reasons." . You need to set some parameters in \www\phpPgAdmin\conf\
find
Now you can login to PostgreSQL using phpPgAdmin and work on it. You can now create database and work on it. But If you tried to export the database you will get another error
Export error: Failed to execute pg_dump (given path in your conf/config.inc.php : /usr/bin/pg_dump). Please, fix this path in your configuration and relog.
This is because you did not set the path correctly . You need to change two other parameters in config.inc.php
Hope this post helps to configure PostgreSQL and phpPgAdmin successfully.
Am using
- PostgreSQL 9.1
- WAMP Server 2.0e
- phpPgAdmin 5.0.2
- 1. Apache Version :2.2.17
- 2. PHP Version :5.3.5
- 3. MySQL Version :5.5.8
Install WAMP server where ever you need.
Download PhpPgAdmin and unzip it to WWW folder in WAMP installation.
At this point if you try to access the http://localhost/phpPgAdmin/ you may get this error.
Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option.
This is because you need to enable two extensions.
- php_pgsql
- php_pdo_pgsql
PHP Warning: PHP Startup: Unable to load dynamic library
'D:/wamp/bin/php/php5.3.5/ext/php_pdo_oci.dll' - The specified module
could not be found.\r\n in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library
'D:/wamp/bin/php/php5.3.5/ext/php_pdo_oci.dll' - The specified module
could not be found. in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library
'D:/wamp/bin/php/php5.3.5/ext/php_pdo_pgsql.dll' - The specified module
could not be found.\r\n in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library
'D:/wamp/bin/php/php5.3.5/ext/php_pdo_pgsql.dll' - The specified module
could not be found. in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library
'D:/wamp/bin/php/php5.3.5/ext/php_pgsql.dll' - The specified module
could not be found.\r\n in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library
'D:/wamp/bin/php/php5.3.5/ext/php_pgsql.dll' - The specified module
could not be found
To correct this error you need to copy libpq.dll from wamp\bin\php\php5.3.5 to wamp\bin\apache\Apache2.2.17\bin . Then try to enable PHP extension and check apache error log you will not see the error . And pgsql will be shown in Loaded extensions in http://localhost/.Now try this http://localhost/phpPgAdmin/ and you will see the PostgreSQL server. Select the PostgreSQL and login using the deafult user "postgres" and the password you given when PostgreSQL installed. You may not able to login. It may say "Login disallowed for security reasons." . You need to set some parameters in \www\phpPgAdmin\conf\
find
$conf['extra_login_security'] = true;and change
$conf['extra_login_security'] = false;
and find$conf['owned_only'] = false;
and change it to$conf['owned_only'] = true;
Now you can login to PostgreSQL using phpPgAdmin and work on it. You can now create database and work on it. But If you tried to export the database you will get another error
Export error: Failed to execute pg_dump (given path in your conf/config.inc.php : /usr/bin/pg_dump). Please, fix this path in your configuration and relog.
This is because you did not set the path correctly . You need to change two other parameters in config.inc.php
$conf['servers'][0]['pg_dump_path'] = '/usr/bin/pg_dump';
$conf['servers'][0]['pg_dumpall_path'] = '/usr/bin/pg_dumpall';
change these params to $conf['servers'][0]['pg_dump_path'] = 'C:\Program Files\PostgreSQL\9.1\bin\pg_dump.exe';
$conf['servers'][0]['pg_dumpall_path'] = 'C:\Program Files\PostgreSQL\9.1\bin\pg_dumpall.exe';
check your PostgreSQL installation directory. Now you can export the database.Hope this post helps to configure PostgreSQL and phpPgAdmin successfully.
Comments
Install WAMP server where ever you need.
Download and unzip it to WWW folder in WAMP installation.
in this section - what did you mean download and unzip "IT"?
Regards,
PHP Training in Chennai|PHP Course in Chennai
Awesome Post! I like writing style, how you describing the topics throughout the post. I hope many web reader will keep reading your post at the end, Thanks for sharing your view.
Regards,
web design training chennai|Best web designing institute in chennai
Regards,
JAVA Training in Chennai|JAVA J2EE Training in Chennai|java courses
Java Training in chennai | Java course in chennai | J2EE Training in Chennai
PHP Training in Chennai | PHP course in Chennai
The strategy you have posted on this technology helped me to get into the next level and had lot of information in it. The python programming language is very popular and most widely used.
Python Training in Chennai | Python Course in Chennai
ERP in Chennai
erp software in chennai
Dot Net Training in Chennai | Dot Net Training Institute in Chennai | Online Training in Chennai
Android Training in Chennai
Ios Training in Chennai
Mobile app development company
ITIL Certification Exam Center in Chennai | ITIL Certification Training in Chennai
Sap Training Institute in Noida
PHP Training Institute in Noida
Hadoop Training Institute in Noida
Oracle Training Institute in Noida
Linux Training Institute in Noida
Dot net Training Institute in Noida
Salesforce training institute in noida
Java training institute in noida
PHP training institute in Chennai | PHP training course
Webseiten Gestaltung LĂĽdenscheid
I have read your blog its very attractive and impressive. I like it your blog.
PHP Training in chennai | PHP Training Course
PHP Training in chennai | Online PHP Course
Webdesign Deutschland
Image Processing Project Center in Chennai | Image Processing Project Center in Velachery
software testing institute in Indirapuram
Aws online training in india
Salesforce online training in india
Flipkart New Year Offers on Mobile Phones
Ebay New Year Offers On Mobile Phones
SEO company in Durban
SEO Company in india
SEO company in Johannesburg
Seo company in washington
Seo company in wakefield
Seo company in virginia
Seo company in usa
Informative and impressive. Keep Updating
Programmierung in LĂĽdenscheid
Sirkus system
sirkus system
Sirkus Systems
sirkus system review
Sirkus System
Sirkus System Reviews
Sirkus System
Sirkus System Review
Java training in indirapuram
Hadoop training in indirapuram
sas training in indirapuram
sap training in indirapuram
linux training in indirapuram
sap fico training in indirapuram
web design training in indirapuram
php training in indirapuram
BE/B.Tech Project Center in Chennai | ME/M.Tech Project Center in Chennai | Final Year Project Center in Chennai
best sas training institutes in noida
best sap training institutes in noida
best linux training institutes in noida
best salesforce training institutes in noida
best software testing training institutes in noida
best oracle training institutes in noida
best android training institutes in noida
best php training institutes in noida
best web design training institutes in noida
best java training institutes in noida
best sap mm training institutes in noida
best sap sd training institutes in noida
best sap hr training institutes in noida
Digital Marketing Training in Noida
Summer internship training in noida
Summer Internship Training in Noida
java training in bangalore
Mobile application developers in Chennai | Android application developers in Chennai | Android app developers Chennai | PHP developers chennai
jobbörse Neunkirchen
white label website builder
mobile website builder
regionale stellenbörse
aws training in Chennai
Thank you for sharing the information. This is very valuable information.
Get keeping your informations and knowledge spreading.
We are one of the leading sap implementation and sap providers in chennai. Pls call +91 - 44 - 4294 9615 to schedule demo or send email to info@sphinaxinfosystems.com
Our site: Sphinax info systems
recognize that other people online have the identical fervor like mine
to grasp great deal more around this condition.
white label website builder
Dissertation Writing Services
Ciitnoida provides Core and java training institute in noida. We have a team of experienced Java professionals who help our students learn Java with the help of Live Base Projects. The object-oriented, class-based build of Java has made it one of most popular programming languages and the demand of professionals with certification in Advance Java training is at an all-time high not just in India but foreign countries too.
By helping our students understand the fundamentals and Advance concepts of Java, we prepare them for a successful programming career. With over 13 years of sound experience, we have successfully trained hundreds of students in Noida and have been able to turn ourselves into an institute for best Java training in Noida.
java training institute in noida
php training in noida
linux training in noida
linux institute in noida
java course in noida
I won’t think twice to endorse your blog post to anybody who wants
and needs support about this area.
white label website builder