Error: Unable to Launch PGACESS

[gwinn7]

Shortly after installing PostgresSQL 7.1 to my RedHat 7.2 server, I attempted to invoke the pgaccess utility. For some bizarre reason, it will only open under the "root" account. If I try one of the two user accounts I created, then it fails with the following error message:


Xlib: connection to ":0.0" refused by server
Xlib: Client is not authorized to connect to Server
Application initialization failed: couldn't connect to display ":0"
Error in startup script: invalid command name "image"
while executing
"image create bitmap dnarw -data {
#define down_arrow_width 15
#define down_arror_height 15
static char down_arrow_bits[] = {
0x00,0x80,0x00,0,80,0x0..."
(file "/usr/share/pgsql/pgaccess/main.tcl" line 5)

The pba_conf is configured properly. Obviously its a client connection issue, but I can't put my finger on how to fix it. Any ideas?

Thanks,
gwinn7

 

[SteveBrett]

it looks like you (or redhat) installed postgresql under the root account with root as the postgresql superuser.

if you run 'createuser' and then follow the prompts you can add users and then conect as that user.

Steve

 

[gwinn7]

Thank you for your response. I just resolved this yesterday and you are correct. The problem was resolved by changing the permissions and user/group assigments for the "data" folder of the postgres database. It now works good now.

Your comments are appreciated. Thank you again!

Gary
gwinn7