Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 17D591337B8A for ; Tue, 8 Feb 2011 12:21:12 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 41481-01-5 for ; Tue, 8 Feb 2011 16:21:04 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 4082B1337BD8 for ; Tue, 8 Feb 2011 12:20:58 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.4/8.14.4) with ESMTP id p18GKvNG061017 for ; Tue, 8 Feb 2011 12:20:57 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.4/8.14.4/Submit) id p18G83wp030697 for pgsql-sql@postgresql.org; Tue, 8 Feb 2011 12:08:03 -0400 (AST) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.sql Subject: Re: Get postgresql server ip address Date: Tue, 08 Feb 2011 10:30:42 -0500 Organization: cbbrowne Computing Inc Lines: 14 Message-ID: <87vd0uzgpp.fsf@cbbrowne.afilias-int.info> References: Mime-Version: 1.0 Content-Type: text/plain X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.0.50 (gnu/linux) Cancel-Lock: sha1:cNtgJivvdcCPLPi+TIT7D1TkBso= To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201102/31 X-Sequence-Number: 35107 geramel.h@gmail.com (Gera Mel Handumon) writes: > Is it possible to get postgresql server ip address using sql command? You can get the IP address tied to a specific connection... See the function inet_server_port(). Note, however, that the server may have a multiplicity of IP addresses, so this may only be a partial answer. -- output = ("cbbrowne" "@" "gmail.com") "A lot of people come to this newsgroup and do nothing but complain about Lisp. I think maybe they are such heavy complainers that they think they read comp.lain.lisp." -- Erik Naggum