<div>
use psql command line client program ?
</div>


<div>
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.
</div>


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.

<div>
I have another server with X. How do I run it from another CentOS 5.1 machine? How do I redirect the display? <br />
<br />
SO I take it there is no psql command line client program ?
</div>


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 ?

<div>
<div class="content wysiwyg-content">
If I run pgadmin, &nbsp;the error message is:<br />
<br />
Error: Unable to initialize gtk, is DISPLAY set properly?<br />
<br />
&nbsp;<br />
<br />
I think this means its expecting to run via X Windows, which is not running.<br />
<br />
&nbsp;<br />
<br />
Currently the display is set to:<br />
<br />
TERM=xterm<br />
<br />
consoletype=pty<br />
<br />
&nbsp;<br />
<br />
How do we setup pgadmin3 to run via the console and not via X windows?<br />
<br />
&nbsp;<br />

</div>
</div>


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:

TERM=xterm

consoletype=pty

 

How do we setup pgadmin3 to run via the console and not via X windows?

 


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

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.