When planning an upgrade for YugabyteDB or YugabyteDB Anywhere (YBA), it is easy to assume that a higher version number automatically means […]
Read MoreFixing a PG15 Upgrade Pre-Check Failure Caused by a Missing pg_hint_plan Hint Table
During a YugabyteDB PostgreSQL 15 upgrade pre-check, you may encounter an error similar to: Performing Consistency Checks on Old Live Server SQL […]
Read MoreDynamically Reload YSQL PostgreSQL Settings and Identity Maps Without Restarting YB-TServers
YugabyteDB exposes several YSQL configuration files through YB-TServer flags. Two particularly useful examples are: ● ysql_pg_conf_csv: controls PostgreSQL server configuration parameters normally […]
Read MoreDynamically Change YSQL HBA Rules Without Restarting YB-TServers
YSQL uses PostgreSQL-style host-based authentication (HBA) rules to determine which clients can connect, which database users they can use, and which authentication […]
Read More