Re: Querying the hostname of the server
От | Ross J. Reedstrom |
---|---|
Тема | Re: Querying the hostname of the server |
Дата | |
Msg-id | 20100430141404.GB28614@rice.edu обсуждение исходный текст |
Ответ на | Querying the hostname of the server (Péter Kovács <maxottovonstirlitz@gmail.com>) |
Ответы |
Re: Querying the hostname of the server
Re: Querying the hostname of the server Re: Querying the hostname of the server Re: Querying the hostname of the server |
Список | pgsql-admin |
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@rice.edu 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
В списке pgsql-admin по дате отправления: