Hi All, <br><br>I set up posgresql on RedHat El4. Below are rpms I installed. <br><br>[root@LinuxBox etc]# rpm -qa |grep postgres<br>postgresql-libs-7.4.16-1.RHEL4.1<br>postgresql-devel-7.4.16-1.RHEL4.1<br>postgresql-7.4.16-1.RHEL4.1
<br>postgresql-python-7.4.16-1.RHEL4.1<br>postgresql-server-7.4.16-1.RHEL4.1<br><br>Then, I did below commands to create a user and a database. <br><br>[root@box root]# su postgres<br><br>bash-3.1$ createuser -adEP test<br>
Enter password for new role:<br>Enter it again:<br><br>bash-3.1$ createdb -O test testdb<br>CREATE DATABASE<br><br>bash-3.1$ exit<br>exit<br><br>Then, I installed phpPgAdmin rpm.<br><br>[root@LinuxBox etc]# rpm -qa |grep phpPgAdmin
<br>phpPgAdmin-4.0.1-1<br><br>Then, After I logined to phpPgAdmin via web browser as below <br><br> <a href="http://ipaddress/phpPgAdmin/">http://ipaddress/phpPgAdmin/</a><br><br>Then, I got below erros. <br><br clear="all">
<br><p><b>SQL error:</b><br></p><pre style="font-weight: bold;" class="data"><font size="4">ERROR: relation "pg_user" does not exist</font></pre>
<p><b>In statement:</b><br>SELECT usesuper FROM pg_user WHERE usename='test'</p>
<br>
<div class="topbar"><table width="100%"><tbody><tr><td><span class="platform">PostgreSQL 7.4.16</span> running on <span class="host"></span>:<span class="port">5432</span> -- You are logged in as user "<span class="username">
test</span>", <span class="date">11th May, 2007 3:12PM</span></td><td align="right"><a class="toplink" href="http://124.43.200.74/phpPgAdmin/sqledit.php?server=%3A5432&action=sql" target="sqledit" onclick="window.open('sqledit.php?server=%3A5432&action=sql','sqledit::5432','toolbar=no,width=600,height=400,resizable=yes,scrollbars=no').focus(); return false;">
SQL</a> | <a class="toplink" href="http://124.43.200.74/phpPgAdmin/sqledit.php?server=%3A5432&action=find" target="sqledit" onclick="window.open('sqledit.php?server=%3A5432&action=find','sqledit::5432','toolbar=no,width=600,height=400,resizable=yes,scrollbars=no').focus(); return false;">
Find</a> | <a class="toplink" href="http://124.43.200.74/phpPgAdmin/servers.php?action=logout&logoutServer=:5432">Logout</a></td></tr></tbody></table></div>
<div class="trail"><table><tbody><tr><td><a href="http://124.43.200.74/phpPgAdmin/redirect.php?subject=root">phpPgAdmin</a>: </td><td><a href="http://124.43.200.74/phpPgAdmin/redirect.php?subject=server&server=%3A5432&" title="Server">
PostgreSQL</a><a class="help" href="http://124.43.200.74/phpPgAdmin/help.php?help=pg.server&server=%3A5432" title="Help" target="phppgadminhelp">?</a>: </td></tr></tbody></table></div>
<table class="error" cellpadding="5"><tbody><tr><td><p><b>SQL error:</b><br></p><pre style="font-weight: bold;" class="data"><font size="4">ERROR: relation "pg_user" does not exist</font></pre>
<p><b>In statement:</b><br>SELECT usesuper FROM pg_user WHERE usename='test'</p>
</td></tr></tbody></table><br>
<table class="tabs"><tbody><tr>
<td class="tab active" width="14%"><a href="http://124.43.200.74/phpPgAdmin/all_db.php?subject=server&server=%3A5432">Databases</a><a class="help" href="http://124.43.200.74/phpPgAdmin/help.php?help=pg.database&server=%3A5432" title="Help" target="phppgadminhelp">
?</a></td>
<td class="tab" width="14%"><a href="http://124.43.200.74/phpPgAdmin/users.php?subject=server&action=account&server=%3A5432">Account</a><a class="help" href="http://124.43.200.74/phpPgAdmin/help.php?help=pg.user&server=%3A5432" title="Help" target="phppgadminhelp">
?</a></td>
<td class="tab" width="14%"><a href="http://124.43.200.74/phpPgAdmin/all_db.php?subject=server&action=export&server=%3A5432">Export</a></td>
<td class="tab" width="14%"><a href="http://124.43.200.74/phpPgAdmin/reports.php?subject=server&server=%3A5432">Reports</a></td>
</tr></tbody></table>
<p><b>SQL error:</b><br></p><pre style="font-weight: bold;" class="data"><font size="4">ERROR: relation "pg_user" does not exist</font></pre>
<p><b>In statement:</b><br></p><pre class="data">SELECT pdb.datname AS datname, pu.usename AS datowner, pg_encoding_to_char(encoding) AS datencoding,<br> (SELECT description FROM pg_description pd WHERE
pdb.oid=pd.objoid) AS datcomment<br> FROM pg_database pdb, pg_user pu<br> WHERE pdb.datdba = pu.usesysid<br> AND NOT pdb.datistemplate<br> <br> ORDER BY pdb.datname</pre><br>Why . Pls help me to solve this.
<br><br>
<br>-- <br>Thank you<br>Indunil Jayasooriya<br>