Implement fallback_application_name

This is a libpq-compatible parameter which can be used by generic
programs to provide a "default" application_name the user can override
via application_name or PGAPPNAME.