Thread: Server Status Activity grid
<div class="WordSection1"><p class="MsoNormal">Hi Group,<p class="MsoNormal"> <p class="MsoNormal">I think I’ve asked thisquestion before a long time ago but I’m hoping to get a different answer this time. :D<p class="MsoNormal"> <p class="MsoNormal">InpgAdmin III - 1.16.1, on the Server Status screen, the Activity grid lists current database connections.<pclass="MsoNormal"> <p class="MsoNormal">The Application name column very clearly lists pgAdmin III connections,which is great, but if my application also has an active connection or two or three, the Application name columnis blank. <p class="MsoNormal"> <p class="MsoNormal">My question is, where is the Application name column pullingits data from? A PostgreSQL catalog table? A parameter? Dark magic? I would like to see that the connection comesfrom my app in the grid, as opposed to some other source.<p class="MsoNormal"> <p class="MsoNormal">Thanks,<p class="MsoNormal"> <pclass="MsoNormal">Chris<p class="MsoNormal"> </div>
Chris Campbell-14 wrote > My question is, where is the Application name column pulling its data > from? http://www.postgresql.org/docs/9.2/interactive/runtime-config-logging.html Section 18.8.3 "application_name" Issue a: SET application_name = 'my_application'; command upon establishing a connection. Probably can setup this on a per-user basis if desired. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Server-Status-Activity-grid-tp5768874p5768875.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
> Chris Campbell-14 wrote > > My question is, where is the Application name column pulling its data > > from? > > http://www.postgresql.org/docs/9.2/interactive/runtime-config- > logging.html > > Section 18.8.3 > > "application_name" > > Issue a: > > SET application_name = 'my_application'; > > command upon establishing a connection. Probably can setup this on a > per-user basis if desired. > > David J. > Hi David. Thank you for your reply. I'm developing in a .net environment and for posterity purposes will document the methodI used thanks to your suggestion. I use a 3rd party component called dotConnect for PostgreSQL (From Devart) for mydata connection. string strAppName = "MyApp"; string strCurrentUser = "CurrentUser"; oCommand = mydataconnection.CreateCommand; oCommand.CommandText = "set application_name = '" + strAppName + "-" + strCurrentUser + "'"; oCommand.ExecuteNonQuery(); Looking at the answer now I suppose it would have been more appropriate to post this question in a different forum, but sinceI spotted what I wanted in pgAdmin it made sense to me to start here. FYI, I use pgAdmin daily and am grateful for all the hard work you people put into it. Thanks again, Chris