Postgres installation issue

Question

I have been using Wamp server for a long time now. It comes with MySQL. Today I had to change from mysql to PostgreSQL. I've tried install Postgres, downloaded and completed the installation. But when I tried to run a php program to reteive some data from the table,

<?php
$link = pg_connect("host=192.168.2.43 dbname=DataFetcher user=postgres password=user");
echo "Connection Established";
?>

it says Call to undefined function pg_connect(), that means Postgres is not detected.

What could be the issue?

Was your PHP version built with Postgresql support? Check phpinfo() and have a look at php.net/manual/en/pgsql.installation.php. — Felix Kling
– Felix Kling, Commented May 31, 2012 at 10:17
Can you connect to Postgres using it's commandline tool psql? — user330315
– user330315, Commented May 31, 2012 at 10:50
no..Im a starter in postgres, I was trying to install it and wnt to know mre abt it by using it..bt I cnt get this thing started — user1371896
– user1371896, Commented May 31, 2012 at 10:54

xdazz · Accepted Answer · 2012-05-31 10:18:45Z

1

You need to enable the extention.

Something like left click wamp icon goto - php > extentions and click php_pgsql.

answered May 31, 2012 at 10:18

xdazz

161k38 gold badges255 silver badges278 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

user1371896 Over a year ago

should I disable anything related to mysql?

xdazz Over a year ago

@user1371896 Have you restarted the server?

xdazz Over a year ago

@user1371896 No, it has nothing related with mysql.

user1371896 Over a year ago

anything to be changed in the file php.ini

Philip Couling Over a year ago

This is fairly clearly an issue with not having the extension. Create a page containing just <?php phpinfo(); ?>. This will let you view your PHP setup. If the extension doesn't get listed on the resulting page, then its not installed correctly. This isn't a problem with postgresql and definitely not mysql.

|

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

I had the same issue. I installed wamp, enabled php_pgsql and php_pdo_pgsql successfully. But I was still unable to see pgsql installed on apache server. I found a nice explanation and solution provided by @skoobiedu at http://forum.wampserver.com/read.php?2,40270,40311

P.S. I have again given this answer because this is the correct answer for this question and @Bill deleted my answer. I request @user1371896 to accept this answer as correct answer. I also request @bill not to delete this answer as I have already removed same answer from one other post.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jun 1, 2012 at 11:50

Dhairya Vora

1,27912 silver badges36 bronze badges

1 Comment

Dhairya Vora Over a year ago

I had given same answer on one more posted question. So he deleted my answer. I didn't know that we can't give same answers to different posts. Actually i should have given you the link to the duplicate answer. And by the way now i have deleted the duplicate answer. now this is the only answer.

Collectives™ on Stack Overflow

Postgres installation issue

2 Answers 2

10 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related