Summary:
This revision introduces support for dumping profile (`pg_yb_profile`) and role profile mapping (`pg_yb_role_profile`) in ysql_dumpall. Dumping them can be skipped by providing the `yb-no-profiles` parameter.

Since Profile is a global object similar to Role, it is being dumped alongside Role in ysql_dumpall.
Jira: DB-15015

Test Plan:
./yb_build.sh --java-test org.yb.pgsql.TestYsqlDump
./yb_build.sh --cxx-test integration-tests_ysql_major_upgrade_role_profiles-test --gtest_filter YsqlMajorUpgradeTestWithRoleProfile.RoleProfile

Reviewers: telgersma, aagrawal, hsunder, #db-approvers

Reviewed By: telgersma, #db-approvers

Subscribers: svc_phabricator, hsunder, yql

Differential Revision: https://phorge.dev.yugabyte.com/D44476