DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=2uauTNqxyEJGGC29MkG/nmPM1xmYdIzAueBZYL45YsvmL1hxo4Hk2J3KSiZK0JYKSYXNW/SG9+vpc6Udb/F6t0JzqLRTLCmD2GLouDDbbStI8KNxBSYi1UKXTYo+XkGGKDOosAg04CyKUP2cWfGRsCz5tg2DTY23B6TPaaSUUHY=;
Message-ID: <292551.66852.qm@web23604.mail.ird.yahoo.com>
Date: Fri, 30 Apr 2010 14:43:49 +0000 (GMT)
From: Glyn Astill <glynastill@yahoo.co.uk>
Subject: Re: Querying the hostname of the server
To: pgsql-admin@postgresql.org, "Ross J. Reedstrom" <reedstrm@rice.edu>
In-Reply-To: <20100430141404.GB28614@rice.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

--- On Fri, 30/4/10, Ross J. Reedstrom <reedstrm@rice.edu> wrote:=0A=0A> > =
Hi,=0A> > =0A> > I have a number of PostgreSQL servers which I often=0A> ac=
cess through ssh=0A> > tunnel with Pgadmin3. I would like to double check=
=0A> which one I have landed=0A> > on (if the tunnel is really configured t=
he way I=0A> want). Is there a way to=0A> > query the hostname from the cat=
alogs?=0A> =0A> Hmm, that's a bit tricky, since I assume you're using a=0A>=
 local db=0A> connection inside the tunnel, so inet_server_addr()=0A> proba=
bly returns=0A> null. If you're talking unix/linux machines, then=0A> /etc/=
hostname _should_=0A> have the current hostname in it, so:=0A> =0A> create =
temp table foo (t text);=0A> copy foo from '/etc/hostname';=0A> select * fr=
om foo;=0A> drop table foo;=0A> =0A> Should work.=0A> =0A=0AOr you could do=
 something like:=0A=0ACREATE OR REPLACE FUNCTION hostname()=0ARETURNS text =
AS=0A$BODY$=0A=09$host =3D `hostname`;=0A        return $host;=0A$BODY$=0AL=
ANGUAGE 'plperlu';=0A=0A=0A=0A=0A