How to set application_name for postgres connections?

java postgresql connection-pooling tomcat-jdbc
membersound picture membersound · May 19, 2015 · Viewed 14.3k times · Source

I'm using tomcat connection pool org.apache.tomcat.jdbc.pool.DataSource. The connections appear in my database pg_stat_activity with empty application_name.

How could I set that application name in my java app, so I know where each connection comes from (as there will be multiple applications accessing the same db)?

Answer

Cristian Sevescu picture Cristian Sevescu · May 19, 2015

You could specify the application name in the connection string.
Documentation here.

Example:

jdbc:postgresql://localhost:5435/DBNAME?ApplicationName=MyApp

Take care: the param names are case sensitive.

Related questions

How create an PostgreSQL connection pool using Java?

I'm trying to use a Connection Pool, but I don't understand it right. Who implements it? The software, the driver or the database? How I do to have my program running using a Connection Pool? I'm using the native PostgreSQL …

Read More
Connecting PostgreSQL 9.2.1 with Hibernate

I have a blank Spring MVC project, and I've installed Hibernate and the PostgreSQL drivers using Maven. I'm running short on complete tutorials that show how to connect PostgreSQL with Hibernate. Any help here?

Read More
Is it possible to specify the schema when connecting to postgres with JDBC?

Is it possible? Can i specify it on the connection URL? How to do that?

Read More