Skip site navigation (1) Skip section navigation (2)

Re: pgaccess

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: paul simdars <psimdars(at)lisco(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: pgaccess
Date: 2002-02-21 22:46:04
Message-ID: 1014331565.3217.938.camel@linda (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
On Wed, 2002-02-20 at 20:50, paul simdars wrote:
> In Xwindow, if I su to root and type pgaccess, the window comes up.
> When I su to postgres or my regular user account and type pgaccess I get
> error messages, they start like this :

This is not a pgaccess error; it is because of the way you are using X
The same would apply if you ran xterm or xeyes.

> 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"

This is because the new user which you have become does not have
authority to use your X session.  One way to solve it is to do

 export XAUTHORITY=~/.Xauthority

as the user who starts X, which will work if you su to root, but not to
another non-superuser, because that user will not be able to read the

Alternatively do 

 xhost +localhost

which should allow any user on localhost to connect to your X session

Oliver Elphick                                Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight                    
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "My sheep hear my voice, and I know them, and they 
      follow me; And I give unto them eternal life; and they
      shall never perish, neither shall any man pluck them 
      out of my hand."          John 10:27,28 

In response to

  • pgaccess at 2002-02-20 20:50:26 from paul simdars


pgsql-interfaces by date

Next:From: Stephen DaviesDate: 2002-02-21 23:06:49
Subject: Re: serious problems with BOOL and Access
Previous:From: Tim BarnardDate: 2002-02-21 22:11:52
Subject: Re: libpq++ problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group