Thread: Graphics in postgress using GTK
Hi We are trying to implement a progress estiamator for long queries. We are trying to make the display graphical using GTK but we get an error saying Xlib : Connection to ":0.0" refused by server xlib : no protocol specified GTK-warning ** : Cannot open display Can someone suggest a method to integrate this GTK code into postgres and solve this problem. Thanks and Regards Anuj Tripathi
On Fri, Dec 02, 2005 at 04:15:55PM +0530, Anuj Tripathi wrote: > Hi > We are trying to implement a progress estiamator for long queries. We > are trying to make the display graphical using GTK but we get an error > saying > Xlib : Connection to ":0.0" refused by server > xlib : no protocol specified Err, why on earth would the *backend* need to talk to the X server. Shouldn't it be sending messages to the client and then the client making the pics? How do you plan to deal with 10 queries running simultaneously on a server at the other side of the world. I'm not even running an X-server on my database server... Anyway, the database server doesn't have permissions to access the X server, that's the error. > Can someone suggest a method to integrate this GTK code into postgres > and solve this problem. Umm, don't? Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Anuj Tripathi wrote: > Hi > We are trying to implement a progress estiamator for long queries. We > are trying to make the display graphical using GTK but we get an error > saying > Xlib : Connection to ":0.0" refused by server > xlib : no protocol specified > > GTK-warning ** : Cannot open display > > Can someone suggest a method to integrate this GTK code into postgres > and solve this problem. Um - don't you want to be doing this in the client, not in the backend? -- Richard Huxton Archonet Ltd
What are you doing? Trying to run the GTK application in the same server as
the database?
Or are you trying to do a graphical interface in a server without an X
server?. I guess there is something very bad with your approach, I guess
your graphical interface should be running in the client side NOT in the
server side.
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Anuj Tripathi
Sent: Viernes, 02 de Diciembre de 2005 04:46 a.m.
To: pgsql-hackers@postgresql.org
Subject: [HACKERS] Graphics in postgress using GTK
Hi
We are trying to implement a progress estiamator for long queries. We
are trying to make the display graphical using GTK but we get an error
saying
Xlib : Connection to ":0.0" refused by server
xlib : no protocol specified
GTK-warning ** : Cannot open display
Can someone suggest a method to integrate this GTK code into postgres
and solve this problem.
Thanks and Regards
Anuj Tripathi
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On 12/2/05, Anuj Tripathi <anujt@it.iitb.ac.in> wrote: > Hi > We are trying to implement a progress estiamator for long queries. We > are trying to make the display graphical using GTK but we get an error > saying > Xlib : Connection to ":0.0" refused by server > xlib : no protocol specified > > GTK-warning ** : Cannot open display > > Can someone suggest a method to integrate this GTK code into postgres > and solve this problem. > > Thanks and Regards > Anuj Tripathi > > What about to return to your application a cursor or a set of rows and while looping let your progress bar advance? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)