How to set application_name for postgres connections?

java postgresql connection-pooling tomcat-jdbc

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.

java postgresql connection-pooling tomcat-jdbc

Use set command:

set application_name to my_application;

java postgresql connection-pooling tomcat-jdbc

You can add this to the JDBC URL that you use in your connection pool definition:

jdbc:postgresql://localhost/postgres?ApplicationName=my_app

If you want to change it dynamically e.g. to reflect different modules inside your application, the you can use the SET command as shown by klin.

CodeHunter