pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhost name?
9+ messages / 5 participants
[nested] [flat]
* host name?
@ 2007-02-26 15:28 Igor Neyman <ineyman@perceptron.com>
2007-02-26 15:56 ` Re: host name? Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2007-02-26 16:20 ` Re: host name? Igor Neyman <ineyman@perceptron.com>
0 siblings, 2 replies; 9+ messages in thread
From: Igor Neyman @ 2007-02-26 15:28 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: host name?
2007-02-26 15:28 host name? Igor Neyman <ineyman@perceptron.com>
@ 2007-02-26 15:56 ` Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2007-02-26 16:47 ` Re: host name? Igor Neyman <ineyman@perceptron.com>
1 sibling, 1 reply; 9+ messages in thread
From: Andy Shellam (Mailing Lists) @ 2007-02-26 15:56 UTC (permalink / raw)
To: Igor Neyman <ineyman@perceptron.com>; +Cc: pgsql-admin
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?
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: host name?
2007-02-26 15:28 host name? Igor Neyman <ineyman@perceptron.com>
2007-02-26 15:56 ` Re: host name? Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
@ 2007-02-26 16:47 ` Igor Neyman <ineyman@perceptron.com>
2007-02-26 17:53 ` Re: host name? Ray Stell <stellr@cns.vt.edu>
0 siblings, 1 reply; 9+ messages in thread
From: Igor Neyman @ 2007-02-26 16:47 UTC (permalink / raw)
To: Andy Shellam \(Mailing Lists\) <andy.shellam-lists@mailnetwork.co.uk>; +Cc: pgsql-admin
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?
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: host name?
2007-02-26 15:28 host name? Igor Neyman <ineyman@perceptron.com>
2007-02-26 15:56 ` Re: host name? Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2007-02-26 16:47 ` Re: host name? Igor Neyman <ineyman@perceptron.com>
@ 2007-02-26 17:53 ` Ray Stell <stellr@cns.vt.edu>
2007-02-26 18:26 ` Re: host name? Igor Neyman <ineyman@perceptron.com>
2007-02-26 18:27 ` Re: host name? Igor Neyman <ineyman@perceptron.com>
0 siblings, 2 replies; 9+ messages in thread
From: Ray Stell @ 2007-02-26 17:53 UTC (permalink / raw)
To: Igor Neyman <ineyman@perceptron.com>; +Cc: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>; pgsql-admin
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.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: host name?
2007-02-26 15:28 host name? Igor Neyman <ineyman@perceptron.com>
2007-02-26 15:56 ` Re: host name? Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2007-02-26 16:47 ` Re: host name? Igor Neyman <ineyman@perceptron.com>
2007-02-26 17:53 ` Re: host name? Ray Stell <stellr@cns.vt.edu>
@ 2007-02-26 18:26 ` Igor Neyman <ineyman@perceptron.com>
1 sibling, 0 replies; 9+ messages in thread
From: Igor Neyman @ 2007-02-26 18:26 UTC (permalink / raw)
To: Ray Stell <stellr@cns.vt.edu>; +Cc: Andy Shellam \(Mailing Lists\) <andy.shellam-lists@mailnetwork.co.uk>; pgsql-admin
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: host name?
2007-02-26 15:28 host name? Igor Neyman <ineyman@perceptron.com>
2007-02-26 15:56 ` Re: host name? Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2007-02-26 16:47 ` Re: host name? Igor Neyman <ineyman@perceptron.com>
2007-02-26 17:53 ` Re: host name? Ray Stell <stellr@cns.vt.edu>
@ 2007-02-26 18:27 ` Igor Neyman <ineyman@perceptron.com>
2007-02-26 19:06 ` Re: host name? Peter Eisentraut <peter_e@gmx.net>
1 sibling, 1 reply; 9+ messages in thread
From: Igor Neyman @ 2007-02-26 18:27 UTC (permalink / raw)
To: Ray Stell <stellr@cns.vt.edu>; +Cc: Andy Shellam \(Mailing Lists\) <andy.shellam-lists@mailnetwork.co.uk>; pgsql-admin
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: host name?
2007-02-26 15:28 host name? Igor Neyman <ineyman@perceptron.com>
2007-02-26 15:56 ` Re: host name? Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2007-02-26 16:47 ` Re: host name? Igor Neyman <ineyman@perceptron.com>
2007-02-26 17:53 ` Re: host name? Ray Stell <stellr@cns.vt.edu>
2007-02-26 18:27 ` Re: host name? Igor Neyman <ineyman@perceptron.com>
@ 2007-02-26 19:06 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 9+ messages in thread
From: Peter Eisentraut @ 2007-02-26 19:06 UTC (permalink / raw)
To: pgsql-admin; +Cc: Igor Neyman <ineyman@perceptron.com>; Ray Stell <stellr@cns.vt.edu>; Andy Shellam \(Mailing Lists\) <andy.shellam-lists@mailnetwork.co.uk>
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/
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: host name?
2007-02-26 15:28 host name? Igor Neyman <ineyman@perceptron.com>
@ 2007-02-26 16:20 ` Igor Neyman <ineyman@perceptron.com>
2007-02-27 08:15 ` Re: host name? Achilleas Mantzios <achill@matrix.gatewaynet.com>
1 sibling, 1 reply; 9+ messages in thread
From: Igor Neyman @ 2007-02-26 16:20 UTC (permalink / raw)
To: Igor Neyman <ineyman@perceptron.com>; pgsql-admin
And one more question.
Is there a way (function/view) to find machine name on which user
program (connected to Postgres) runs?
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: host name?
2007-02-26 15:28 host name? Igor Neyman <ineyman@perceptron.com>
2007-02-26 16:20 ` Re: host name? Igor Neyman <ineyman@perceptron.com>
@ 2007-02-27 08:15 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 9+ messages in thread
From: Achilleas Mantzios @ 2007-02-27 08:15 UTC (permalink / raw)
To: pgsql-admin
Στις Δευτέρα 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
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2007-02-27 08:15 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-26 15:28 host name? Igor Neyman <ineyman@perceptron.com>
2007-02-26 15:56 ` Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2007-02-26 16:47 ` Igor Neyman <ineyman@perceptron.com>
2007-02-26 17:53 ` Ray Stell <stellr@cns.vt.edu>
2007-02-26 18:26 ` Igor Neyman <ineyman@perceptron.com>
2007-02-26 18:27 ` Igor Neyman <ineyman@perceptron.com>
2007-02-26 19:06 ` Peter Eisentraut <peter_e@gmx.net>
2007-02-26 16:20 ` Igor Neyman <ineyman@perceptron.com>
2007-02-27 08:15 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
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