PGACCESS PB ON REDHAT 5.2 - Mailing list pgsql-interfaces
From | Brajon, L & C |
---|---|
Subject | PGACCESS PB ON REDHAT 5.2 |
Date | |
Msg-id | 369520D3.BED4C700@club-internet.fr Whole thread Raw |
List | pgsql-interfaces |
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 />
pgsql-interfaces by date: