X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 80EEA9F9B76 for ; Thu, 4 May 2006 17:46:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 56741-08 for ; Thu, 4 May 2006 17:46:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id AF1739F9C10 for ; Thu, 4 May 2006 17:46:33 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Thu, 4 May 2006 20:46:29 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 04 May 2006 15:46:29 -0500 Subject: Re: How to find current running process From: Scott Marlowe To: Shivaji S Cc: "Tomeh,Husam" , pgsql-admin@postgresql.org In-Reply-To: <20060504202117.32050.qmail@webmail46.rediffmail.com> References: <20060504202117.32050.qmail@webmail46.rediffmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1146775589.22037.53.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 04 May 2006 15:46:29 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/48 X-Sequence-Number: 21580 On Thu, 2006-05-04 at 15:21, Shivaji S wrote: > tom thanks for the input ,but the below queries doesn't support for my > postgres version 7.1.1 it shows the error > > ERROR: Function 'pg_postmaster_start_time()' does not exist > Unable to identify a function that satisfies the given argument types > You may need to add explicit typecasts That's a seriously OLD OLD OLD version of PostgreSQL. It has known data loss and stability bugs, as well as the deadly transaction wrap around issue. I'd recommend updating to at least 8.0.x where x is the highest version currently out yet) or better yet go to 8.1. You'll get no sympathy from anyone here if or when your 7.1.x database acts up...