Téo, <p>** For your information : <br />The pgsql-interfaces@postgresql.org mailing list adress doesn't seem to work
properly.<br />The brave robot didn't answer me anything... <br /> <p>Bien voici donc plus d'information <br />Well,
hereare the information you need <br /> <p><b>1/ OS version : RedHat 5.2</b><br /><b> PostgreSQL version :
6.3.2</b><br/><b> Pgaccessversion: 0.90</b><br /> <br /> <b></b><p><b>2/ Was PostgreSQL started with the -i
option </b>NO <p>Now yes: <p>$postgres -i <p>postgres does not know where to find the database system data. You must
specifythe directory that contains the database system either by specifying the -D invocation option or by setting the
PGDATAenvironment variable. <p>(????Despite of my effort I did not get this command running??????) <p>=> Postmaster
isrunning: launch as daemon at boot time <p>However if I execute psql all seems going right: <p>I am loged on
postgresqlas posgres user (su -l postgres) <br />I am under: /var/lib/pgsql <p>results: (two tests) <p>(1) $ psql
template1<p>Welcome to the POSTGRESQL interactive sql monitor: <br /> Please read the file COPYRIGHT for copyright
termsof POSTGRESQL <p> type \? for help on slash commands <br /> type \q to quit <br /> type \g or terminate with
semicolonto execute query <br /> You are currently connected to the database: template1 <p>template1=> <p>(2) $psql
-l<p>Welcome to the POSTGRESQL interactive sql monitor: <br /> Please read the file COPYRIGHT for copyright terms of
POSTGRESQL<p> type \? for help on slash commands <br /> type \q to quit <br /> type \g or terminate with
semicolonto execute query <br /> You are currently connected to the database: template1 <p>template1=> \q <br
/>[postgres@localhostpgsql]$ psql -l <br />datname |datdba|datpath <br />---------+------+--------- <br />template1|
100|template1<br />postgres | 100|postgres <br />madb | 100|madb <br />(3 rows) <p>Well all sems OK... <br />
<p><b>3/Result of grep -v "^#" pg_hba.conf:</b><p>local all trust <br
/>host all 127.0.0.1 255.255.255.255 trust <br /> <p><b>4/ Results of the simple command
pgaccess:</b><p>(1)loged as postgres user <br />$pgaccess <p>Application initialization failed: no display name and no
$DISPLAYenvironment variable <br />Error in startup script: invalid command name "option" <br /> while executing <br
/>"optionadd *$wid.font -Adobe-Helvetica-Medium-R-Normal-*-*-120-*-*-*-*-*" <br /> (procedure "init" line 4) <br
/> invoked from within <br />"init $argc $argv" <br /> (file "/usr/bin/pgaccess" line 57) <p>(2) Loged as toor
(sameid as root) <p>see the jpeg file: capture.jpg <br /> <br /> <p><b>5/ Where is the documentation for pgaccess?
</b>Nothingon the RedHat 5.2 distribution, <br />nothing on the flex.ro site?? <br />Où est la doc? On ne trouve aucune
infonulle part!! <br /> <p>Multu mesc ci La revedere! <br /> <p>Cordialement, <br /> <p>Christophe (Eu nu vorbesc
romaneste) <br /> <br /> <br /> <br />