From: Glyn Astill <glynastill@yahoo.co.uk>
To: pgsql-admin@postgresql.org, "Ross J. Reedstrom" <reedstrm@rice.edu>
Subject: Re: Querying the hostname of the server
Date: Fri, 30 Apr 2010 14:43:49 +0000 (GMT)
Message-ID: <292551.66852.qm@web23604.mail.ird.yahoo.com> (raw)
In-Reply-To: <20100430141404.GB28614@rice.edu>
--- On Fri, 30/4/10, Ross J. Reedstrom <reedstrm@rice.edu> wrote:
> > 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?
>
> Hmm, that's a bit tricky, since I assume you're using a
> local db
> connection inside the tunnel, so inet_server_addr()
> probably returns
> null. If you're talking unix/linux machines, then
> /etc/hostname _should_
> have the current hostname in it, so:
>
> create temp table foo (t text);
> copy foo from '/etc/hostname';
> select * from foo;
> drop table foo;
>
> Should work.
>
Or you could do something like:
CREATE OR REPLACE FUNCTION hostname()
RETURNS text AS
$BODY$
$host = `hostname`;
return $host;
$BODY$
LANGUAGE 'plperlu';
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: glynastill@yahoo.co.uk, reedstrm@rice.edu
Subject: Re: Querying the hostname of the server
In-Reply-To: <292551.66852.qm@web23604.mail.ird.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox