/var/lib/pgsql/data/pg_hba.conf

 

http://www.cnblogs.com/mchina/archive/2012/06/06/2539003.html

postgresAdmin3

http://www.cnblogs.com/mchina/archive/2012/06/06/2539003.html

 

http://jingyan.baidu.com/article/3ea51489ec3cb452e71bba52.html

 

http://developer.51cto.com/art/201401/426225.htm

 

调试方法

[root@linux ~]# php /var/www/html/pgsql.php

PHP Warning:  pg_connect(): Unable to connect to PostgreSQL server: FATAL:  Ident authentication failed for user "postgres" in /var/www/html/pgsql.php on line 3

连接失败，不能连接到数据库[root@linux ~]#

看起来是帐号密码的问题

PostgreSQL 数据库默认会创建一个postgres的数据库用户作为数据库的管理员，默认密码为空，我们需要修改为指定的密码，这里设定为’postgres’。

 

# su - postgres

 

$ psql

 

postgres=# ALTER USER postgres WITH PASSWORD 'postgres';

ALTER ROLE

postgres=# select * from pg_shadow ;

 usename  | usesysid | usecreatedb | usesuper | usecatupd |               passwd

                | valuntil | useconfig

----------+----------+-------------+----------+-----------+---------------------

----------------+----------+-----------

 dbuser   |    16384 | f           | f        | f         | md5baa6c789c3728a1a4

49b82005eb54a19 |          |

 postgres |       10 | t           | t        | t         | md53175bce1d3201d165

94cebf9d7eb3f9d |          |

(2 rows)

postgres=# \l

                                  List of databases

   Name    |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileg

es   

-----------+----------+----------+-------------+-------------+------------------

-----

 david     | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres

                                                             : postgres=CTc/post

gres

 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres

                                                             : postgres=CTc/post

gres

 testdb    | dbuser   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/dbuser

                                                             : dbuser=CTc/dbuser

(5 rows)

postgres=# ALTER USER dbuser WITH PASSWORD 'dbuser';

ALTER ROLE

postgres=# \l

                                  List of databases

   Name    |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileg

es   

-----------+----------+----------+-------------+-------------+------------------

-----

 david     | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres

                                                             : postgres=CTc/post

gres

 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres

                                                             : postgres=CTc/post

gres

 testdb    | dbuser   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/dbuser

                                                             : dbuser=CTc/dbuser

(5 rows)

不过仍然有Ident authentication failed for user错误，

尝试修改 /var/lib/pgsql/data/pg_hba.conf， 去掉

#host    all         all         127.0.0.1/32          ident

service postgresql restart

service httpd restart

service postgresql restart

重新执行php,发现这次dbuser能访问了，只是dbuser 数据库不存在

[root@linux ~]# php /var/www/html/pgsql.php

PHP Warning:  pg_connect(): Unable to connect to PostgreSQL server: FATAL:  database "dbuser" does not exist in /var/www/html/pgsql.php on line 3

连接失败，不能连接到数据库[root@linux ~]#

 

修改php脚本：

<?php

// 连接，选择数据库

$dbconn = pg_connect("host=127.0.0.1 dbname=david user=dbuser password=dbuser");

//see if our connection was successful

if (!$dbconn) {

    //connection failed - exit the page with an error

    //you could also try to proceed without the

    //database - it's up to you

     echo "连接失败，不能连接到数据库";

    exit;

}else{

    echo "连接成功";

}

echo "<br>php配置详细信息如下：";

echo phpinfo();

// 关闭连接

pg_close($dbconn);

?>

这次命令行执行php 可以成功显示数据，但是用firefox执行该脚本，仍然显示error , Why?