Обсуждение: host name?

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

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.

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

 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

Igor Neyman wrote:
> But besides having ip address (instead of machine name), it doesn't
> have clent program name connected to PG.

That information is not available to the server.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Στις Δευτέρα 26 Φεβρουάριος 2007 18:20, ο/η Igor Neyman έγραψε:
> And one more question.
> Is there a way (function/view) to find machine name on which user
> program (connected to Postgres) runs?

You could write a stored procedure
in plsh which simply returns the result of /bin/hostname


>
> Igor
>
> ________________________________
>
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Igor Neyman
> Sent: Monday, February 26, 2007 10:29 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] host name?
>
>
> 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

--
Achilleas Mantzios