pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ray Stell <stellr@cns.vt.edu>
To: Igor Neyman <ineyman@perceptron.com>
Cc: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
Cc: pgsql-admin@postgresql.org
Subject: Re: host name?
Date: Mon, 26 Feb 2007 12:53:18 -0500
Message-ID: <20070226175318.GB7269@cns.vt.edu> (raw)
In-Reply-To: <F4C27E77F7A33E4CA98C19A9DC6722A201ADF6C0@EXCHANGE.corp.perceptron.com>
References: <F4C27E77F7A33E4CA98C19A9DC6722A201ADF5FD@EXCHANGE.corp.perceptron.com>
	<45E30326.20107@mailnetwork.co.uk>
	<F4C27E77F7A33E4CA98C19A9DC6722A201ADF6C0@EXCHANGE.corp.perceptron.com>



not sure how to resolve the name, but maybe this is close
enough:

select usename, client_addr from pg_catalog.pg_stat_activity;


On Mon, Feb 26, 2007 at 11:47:13AM -0500, Igor Neyman wrote:
> You are right, wrong question.
> What I really want to know is formulated in my next message.
> Which is: based on program (connected to PG) name find the machine name
> it runs on.
>  
> For those familiar with Oracle, it's program, machine columns in
> v$session view.
> 
> Igor
>  
> ________________________________
> 
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Andy Shellam
> (Mailing Lists)
> Sent: Monday, February 26, 2007 10:56 AM
> To: Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] host name?
> 
> 
> Igor Neyman wrote: 
> 
> 	Is there a function (or catalog view) that I can call in psql
> and that will tell me host name of the machine on which Postgres
> database is running?
> 	 
> 	Igor
> 
> 
> Surely you need to know this to connect to it in the first place?
> 
> 

-- 
You have no chance to survive make your time.



view thread (9+ messages)  latest in thread

Message-ID: <20070226175318.GB7269@cns.vt.edu>
Permalink:  ../20070226175318.GB7269@cns.vt.edu/
Also on:    postgresql.org/message-id/20070226175318.GB7269@cns.vt.edu

 · 

reply

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: stellr@cns.vt.edu, ineyman@perceptron.com, andy.shellam-lists@mailnetwork.co.uk
  Subject: Re: host name?
  In-Reply-To: <20070226175318.GB7269@cns.vt.edu>

* 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