Avoid re-assigning the global pid for client backends and bg workers when the application_name changes

Avoid re-assigning the global pid for client backends and bg workers when the application_name changes #6941