How do we setup pgadmin3 to run via the console and not via X windows?

Posted on 2008-11-06
Medium Priority
Last Modified: 2013-12-15
If I run pgadmin,  the error message is:

Error: Unable to initialize gtk, is DISPLAY set properly?


I think this means its expecting to run via X Windows, which is not running.


Currently the display is set to:




How do we setup pgadmin3 to run via the console and not via X windows?

Question by:shaunwingin
  • 2
LVL 22

Expert Comment

by:earth man2
ID: 22893755
use psql command line client program ?
LVL 12

Expert Comment

by:Hugh Fraser
ID: 22893995
pgadmin has a graphical display that requires X Windows. if you're not willing to run X on the database server, run pgadmin from another computer that is running X and redirect the display.

Author Comment

ID: 22894046
I have another server with X. How do I run it from another CentOS 5.1 machine? How do I redirect the display?

SO I take it there is no psql command line client program ?
LVL 12

Accepted Solution

Hugh Fraser earned 1500 total points
ID: 22900528
It's standard X display stuff. On the "X" host (I'mm call it xhost.com), allow inbound X connections from the DB host (I'll call it dbhost.com) by typing:

xhost + dbhost.com

Telnet/ssh to dbhost.com and export the DISPLAY variable to point to xhost.com:

export DISPLAY=xhost.com:0.0

Then run pgadmin.

BTW, the command line command is psql as earthman2 stated.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Suggested Courses
Course of the Month17 days, 8 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question