When I first installed 5.3 last year I discovered that Postgres was automatically installed. While exploring MySQL I deleted Postgres, the Postgres user account and deamon, and all other traces. Later on, I wanted to reinstall Postgres but YaST couldn't until I manually added the Postgres account and group. Then I had to manually setup the environmental variables and the fire the deamon in the boot script. When I installed pgaccess it ran from KDE just fine. After I upgraded to 6.0 I deleted it again to make room for Oracle, and later Sybase, for testing purposes. I decided to return to postgres so I deleted Sybase and downloaded postgres 6.4.2 and pgaccess-0.96. I installed the source for postgress and compiled and installed it without problems. I set up the environmental variables, created a user in postress called jerry with all rights. Postgres is started, as postgres, via the default "nohup postmaster > server.log 2>&1 &" and it monitors the default port 5432 nicely. I have my hostname, JLKreps, in hba_conf as 127.0.0.2 and trusted. While logged into Linux as jerry I can "psql template1" (from an xterm of KDE) and I am in. I can do everything in the tutorial while in psql. The 'env' command shows my hostname to be JLKreps. HERE IS MY PROBLEM: I have installed both pgaccess and mpsql. They both come up on KDE but neither can access postgress. They both respond with "Connection to database failed... are you sure posgress is connected TCP/IP(with -i) on port 5432?" It's as if KDE doesn't see the ":/usr/local/pgsql/bin" in PATH, but it's xterm's do. I know what you are thinking: calling "wish -f pgaccess.tcl" from an xterm doesn't work either, even though "env" shows the correct PATH. Anyone run into this? -- JLK Linux, because it's STABLE, the source code is included, the price is right. -- To get out of this list, please send email to [EMAIL PROTECTED] with this text in its body: unsubscribe suse-linux-e Check out the SuSE-FAQ at http://www.suse.com/Support/Doku/FAQ/ and the archive at http://www.suse.com/Mailinglists/suse-linux-e/index.html
