Received: from maia.hub.org (maia-1.hub.org [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7B3C7633B28 for ; Fri, 30 Apr 2010 10:33:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 45021-08 for ; Fri, 30 Apr 2010 13:33:10 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f220.google.com (mail-ew0-f220.google.com [209.85.219.220]) by mail.postgresql.org (Postfix) with ESMTP id D32FD6322F9 for ; Fri, 30 Apr 2010 10:33:18 -0300 (ADT) Received: by ewy20 with SMTP id 20so69609ewy.21 for ; Fri, 30 Apr 2010 06:33:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:sender:received:date :x-google-sender-auth:message-id:subject:from:to:content-type; bh=m9oO1lobxzT3hGyMj5+0pcT9UM3GIKHG8R5dAgPdsrs=; b=U3GFwAmAPVXd0RWkvIPEKkK04D1chpBl/0GJlG9vfCOAmgyV6VzTocpe+i2ktJ66jp o6KWGx6ZK7bRsXpfpjLcBYS7kT7aGt4/5iWYnoD62hRaP5Nv0ei+amqyF20X4ily/Ody YgPTmW7Iz8TgMPOi54s9zk82xV0tZa07zsceY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:date:x-google-sender-auth:message-id:subject :from:to:content-type; b=heaexRP+BHUOJLNyPIvLsDct2E4kwYLeVn8aVBT76cXYxTNALylJQocRUcap+DUSeS KhGWXdITOL0I0HMp/vrodDHlvB1hpz41CsDkajHi7QO8/PPHQAol5skM31mF5YzhsKvw rxObjYTxbBrW4Eb1q44jWPbtyymEGFST3EU8M= MIME-Version: 1.0 Received: by 10.213.47.204 with SMTP id o12mr3966734ebf.24.1272634393388; Fri, 30 Apr 2010 06:33:13 -0700 (PDT) Received: by 10.213.17.6 with HTTP; Fri, 30 Apr 2010 06:33:13 -0700 (PDT) Date: Fri, 30 Apr 2010 15:33:13 +0200 X-Google-Sender-Auth: 5f78632b0e34bd7e Message-ID: Subject: Querying the hostname of the server From: =?UTF-8?B?UMOpdGVyIEtvdsOhY3M=?= To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=001485e8cb6ff269bc0485744859 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.499 tagged_above=-10 required=5 tests=BAYES_05=-0.5, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201004/362 X-Sequence-Number: 34456 --001485e8cb6ff269bc0485744859 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 --001485e8cb6ff269bc0485744859 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 P= gadmin3. I would like to double check which one I have landed on (if the tu= nnel is really configured the way I want). Is there a way to query the host= name from the catalogs?

Thanks
Peter
--001485e8cb6ff269bc0485744859--