Label DB connections so they can be monitored about migrator HOT 3 CLOSED

@kwiatek-kainos it looks like the pg/lib supports application_name as a part of the connection string and can be used like this:

dataSource: "user=postgres dbname=migrator_test host=192.168.99.100 port=55432 sslmode=disable application_name=migrator"

Documentation also mentions that the application_name can be read from PGAPPNAME env variable or even fallback_application_name param.

Can you verify if that's the case?

from migrator.

Yes, I'm well aware of those options but this ticket is about increasing usability of the application.

I believe without this change migrator passes on responsibility to from its own (its implementation) to the end user (his configuration) to make monitoring straightforward.
Consequently usability gets degraded.

As I have given in the example pgjdbc/pgjdbc for Java has a sane default where the end user does not have to configure the driver to achieve the very same result.
I reckon in this regard pgjdbc is easier to use and consider this ticket to be a nice to have feature.

from migrator.

Closing. This can be achieved by configuration.

from migrator.