tar -zxvf pgwatch-1.0.tar.gz

vim README

------------------------------------------------------------

Requirements:

-------------

You will need a handful of components to make this work:

- Apache (webserver) # apache用作web服务器

- PHP 5 (scripting language) # PHP5版本

- pgsql extension for PHP (see http://www.php.net/manual/en/book.pgsql.php) # postgresql的PHP客户端

- Postgresql 9 (to store the data we collect) # postgresql支持最低版本为9

- dblink (contribution module for Postgresql 9) # 需要安装dblink(并非默认安装)

- For now we only support Postgresql >= 9.0 databases.

Older systems cannot be monitored,however,we will

add support for future database releases.

// Connecting,selecting database

$dbconn = pg_connect("host=192.168.30.200 port=5434 dbname=lengzijian user=postgres password=123456")

or die('Could not connect: ' . pg_last_error());

// Performing sql query

$query = 'SELECT * FROM t_user limit 10';

$result = pg_query($query) or die('Query Failed: ' . pg_last_error());

// Printing results in HTML

echo "<table>\n";

while ($line = pg_fetch_array($result,null,PGsql_ASSOC)) {

echo "\t<tr>\n";

foreach ($line as $col_value) {

echo "\t\t<td>$col_value</td>\n";

}

echo "\t</tr>\n";

}

echo "</table>\n";

// Free resultset

pg_free_result($result);

// Closing connection

pg_close($dbconn);

?>