Unix Technical Forum

Re: Server status query problem

This is a discussion on Re: Server status query problem within the pgsql Interfaces Pgadmin Hackers forums, part of the PostgreSQL category; --> -----Original Message----- From: "Andreas Pflug"<pgadmin@pse-consulting.de> Sent: 27/11/05 18:01:01 To: "Dave Page"<dpage@vale-housing.co.uk> Cc: "pgadmin-hackers"<pgadmin-hackers@postgresql.org> Subject: Re: Server status query problem ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Hackers

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 05:45 PM
Dave Page
 
Posts: n/a
Default Re: Server status query problem



-----Original Message-----
From: "Andreas Pflug"<pgadmin@pse-consulting.de>
Sent: 27/11/05 18:01:01
To: "Dave Page"<dpage@vale-housing.co.uk>
Cc: "pgadmin-hackers"<pgadmin-hackers@postgresql.org>
Subject: Re: Server status query problem

> Arg....
> Testing for HOURS, coding it but you already committed it...


Sorry, I left it almost a week first - and figured you just had no objections.

/D

-----Unmodified Original Message-----
Dave Page wrote:
> Hi Andreas,
>
> It was pointed out to me that the server status lock tab doesn't show data
> correctly - specifically, the username is always blank, and the query string
> normally shows up as <backend information unavailable>.
>
> It seems the cause is that most of the stats functions don't take a PID as
> an argument, but a backend ID between 1 and the current number of backends.
>
> A hacked together replacement query looks like the following, but before I
> appy it I just wanted to run it past you and the list in case I missed
> anything:


Arg....
Testing for HOURS, coding it but you already committed it...


Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:45 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com