Right, I looked at pg_stat_activity.
But besides having ip address (instead of machine name), it doesn't have
clent program name connected to PG.
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Ray Stell
Sent: Monday, February 26, 2007 12:53 PM
To: Igor Neyman
Cc: Andy Shellam (Mailing Lists); pgsql-admin@postgresql.org
Subject: Re: [ADMIN] host name?
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.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly