Pgaccess interface to Postgre

Tried to use pgacces with my postgresql, both installed through Yast. When starting pgaccess in terminal, I got the following error message:

…# pgaccess
application-specific initialization failed: no display name and no $DISPLAY environment
Error in startup script: invalid command name “image”
while executing
“image create bitmap dnarw -data {
#define down_arrow_width 15
#define down_arrow_height 15
static char down_arrow_bits] = {
(file “/usr/bin/pgaccess” line 17)

Any ideas, how to fix it?

To me it looks that this program is to be used from the GUI (and thus not by root).

A missing $DISPLAY indicates, that you are trying to run the software under the wrong user account. Don’t use postgres, but your normal user account under which you are logged in to the graphical desktop.
btw.: pgadmin3 is an actively developed and maintained alternative.


Thanks Hank, it worked. :slight_smile:

Hendrik, pgadmin3 looks fine. Thanks! lol!