|
I think you can do something like that as a postgresql user su - postgres psql -c "\! uname -n" or actually you can do that inside of any sql statement psql \!uname -n > Date: Fri, 30 Apr 2010 09:14:04 -0500 > From: reedstrm@xxxxxxxx > To: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: [ADMIN] Querying the hostname of the server > > On Fri, Apr 30, 2010 at 03:33:13PM +0200, Péter Kovács 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. > > Ross > -- > Ross Reedstrom, Ph.D. reedstrm@xxxxxxxx > Systems Engineer & Admin, Research Scientist phone: 713-348-6166 > The Connexions Project http://cnx.org fax: 713-348-3665 > Rice University MS-375, Houston, TX 77005 > GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BEDE > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin |
