cannot connect php to postgres database using pg_connect

Question

I just try to connect my php code to postgres database but unfortunately it is not work, here is my code :

<?php
ini_set ("display_errors", "1");
error_reporting(E_ALL);
   $host        = "host=127.0.0.1";
   $port        = "port=5432";
   $dbname      = "dbname=public";
   $credentials = "user=postgres password=postgres";

   $db = pg_connect( "$host $port $dbname $credentials"  ) or die('Could not connect');;
   if(!$db){
      echo "Error : Unable to open database\n";
   } else {
      echo "Opened database successfully\n";
   }

browser result :

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: database "public" does not exist in /var/www/test/pgtest.php on line 11

anybody know what is wrong here ?

Marek Malczewski · Accepted Answer · 2014-07-13 18:47:26Z

1

Are you sure the name of database is 'public'? As fas as I remember 'public' is a name of default schema inside the PostgreSQL database.

Please make sure the database 'public' really exists.

answered Jul 13, 2014 at 18:47

Marek Malczewski

7048 silver badges8 bronze badges

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

1 Comment

Yusuf Ibrahim Over a year ago

I also tried to connect testdb that just I created and it is still gives same error: Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: database testdb does not exist in /var/www/test/pgtest.php on line 11

Bob Brown · Accepted Answer · 2014-07-13 19:06:51Z

1

From the command line, become the postgres user, start psql, and issue the \list command to list your databases. Be sure the database you're trying to open is in the list.

Be sure your pg_hba.conf file allows the database to be opened.

Remove everything except $dbname from the pg_connect call and allow the API to use the defaults. Add parameters back as indicated by the error message(s).

answered Jul 13, 2014 at 19:06

Bob Brown

1,5222 gold badges13 silver badges27 bronze badges

Comments

Yusuf Ibrahim · Accepted Answer · 2014-07-13 19:12:00Z

0

sorry but finally I found that my question was wrong, public and testdb are Schemes inside postgres database,

answered Jul 13, 2014 at 19:12

Yusuf Ibrahim

1,6595 gold badges24 silver badges50 bronze badges

Collectives™ on Stack Overflow

cannot connect php to postgres database using pg_connect

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related