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

Posted on 2008-11-06
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
    LVL 22

    Expert Comment

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

    Expert Comment

    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

    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

    It's standard X display stuff. On the "X" host (I'mm call it, allow inbound X connections from the DB host (I'll call it by typing:

    xhost +

    Telnet/ssh to and export the DISPLAY variable to point to


    Then run pgadmin.

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

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Over the last ten+ years I have seen Linux configuration tools come and go. In the early days there was the tried-and-true, all-powerful linuxconf that many thought would remain the one and only Linux configuration tool until the end of times. Well,…
    If you have a server on collocation with the super-fast CPU, that doesn't mean that you get it running at full power. Here is a preamble. When doing inventory of Linux servers, that I'm administering, I've found that some of them are running on l…
    Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
    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.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now