Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DC49D9FBA09 for ; Tue, 27 Feb 2007 04:15:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 38456-04-3 for ; Tue, 27 Feb 2007 04:15:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id CCCC29FB8F7 for ; Tue, 27 Feb 2007 04:15:38 -0400 (AST) Received: from host3.dynacom.ondsl.gr ([62.103.35.211] helo=ip216.internal.net) by matrix.gatewaynet.com with esmtp (Exim 4.62) (envelope-from ) id 1HLxUl-0002ud-UX for pgsql-admin@postgresql.org; Tue, 27 Feb 2007 10:15:36 +0200 From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: host name? Date: Tue, 27 Feb 2007 10:15:34 +0200 User-Agent: KMail/1.9.3 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200702271015.35320.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.179 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200702/340 X-Sequence-Number: 24805 =CE=A3=CF=84=CE=B9=CF=82 =CE=94=CE=B5=CF=85=CF=84=CE=AD=CF=81=CE=B1 26 =CE= =A6=CE=B5=CE=B2=CF=81=CE=BF=CF=85=CE=AC=CF=81=CE=B9=CE=BF=CF=82 2007 18:20,= =CE=BF/=CE=B7 Igor Neyman =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5: > And one more question. > Is there a way (function/view) to find machine name on which user > program (connected to Postgres) runs? You could write a stored procedure in plsh which simply returns the result of /bin/hostname > > Igor > > ________________________________ > > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Igor Neyman > Sent: Monday, February 26, 2007 10:29 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] host name? > > > Is there a function (or catalog view) that I can call in psql and that > will tell me host name of the machine on which Postgres database is > running? > > Igor =2D-=20 Achilleas Mantzios