Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 6F7256322F9 for ; Fri, 30 Apr 2010 10:31:08 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 32388-07 for ; Fri, 30 Apr 2010 13:31:00 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ey-out-2122.google.com (ey-out-2122.google.com [74.125.78.25]) by mail.postgresql.org (Postfix) with ESMTP id 09B98632297 for ; Fri, 30 Apr 2010 10:31:00 -0300 (ADT) Received: by ey-out-2122.google.com with SMTP id 22so533674eye.3 for ; Fri, 30 Apr 2010 06:30:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=vwB/WZHP+bfFAVnvkjH6vDGiX5hv7X02Bl22vkjnqZA=; b=fL4lEEu7/u5dD52yBg/nc8B9DeiIiCFc7izX1NJmqNdaZeTL7WVwKzd51z3yojcHbU YNASogx1LlGeaJqrz5myudX8S5XM1+dbLO2c/kUBXdyu5qmCgqx+9VVILoXbwLY0a15v vac+Z/M3P98ZomBAWooLuRX6BnKmZ03d7kyQ4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=SV75omdG+ev28nMrHaj3hpCxD35sltlTbORZSruz+db6k/EleCPax3L3FXLVDkmmh2 7VbdBVFrXZa6o2kU/fHfBCwEmBuiyseP3+zH5ZEWGpG+ki5FEgIWrbhO8VwKzmk1vstU EVa96mYlHUQUlFAihh1Va0wpMe/NY/5ZTXmp8= MIME-Version: 1.0 Received: by 10.213.75.134 with SMTP id y6mr4134512ebj.78.1272634257521; Fri, 30 Apr 2010 06:30:57 -0700 (PDT) Received: by 10.213.17.6 with HTTP; Fri, 30 Apr 2010 06:30:57 -0700 (PDT) Date: Fri, 30 Apr 2010 15:30:57 +0200 Message-ID: Subject: How to query hostname of the server From: =?UTF-8?B?UMOpdGVyIEtvdsOhY3M=?= To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=00c09f8c230bd93e2a04857440c7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.888 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201005/32 X-Sequence-Number: 34505 --00c09f8c230bd93e2a04857440c7 Content-Type: text/plain; charset=UTF-8 Hi, I have a number of PostgreSQL servers which I often access through ssh tunnel with Pgadmin3. I would like to double check which one I have landed on (if the tunnel is really configured the way I want). Is there a way to query the hostname from the catalogs? Thanks Peter --00c09f8c230bd93e2a04857440c7 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi,

I have a number of PostgreSQL servers which I often = access through ssh tunnel with Pgadmin3. I would like to double check which= one I have landed on (if the tunnel is really configured the way I want). = Is there a way to query the hostname from the catalogs?

Thanks
Peter
--00c09f8c230bd93e2a04857440c7--