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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Ray Stell Sent: Monday, February 26, 2007 12:53 PM To: Igor Neyman Cc: Andy Shellam (Mailing Lists); pgsql-admin@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxxx > [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Andy Shellam > (Mailing Lists) > Sent: Monday, February 26, 2007 10:56 AM > To: Igor Neyman > Cc: pgsql-admin@xxxxxxxxxxxxxx > 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@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
