Upgrading the major PostgreSQL version in Yandex Managed Service for PostgreSQL

• Do I need to run ANALYZE and/or REINDEX and refresh statistics (pg_stat_user_tables and pg_statistic) manually after upgrading the major PostgreSQL version ?
• Does Managed Service for PostgreSQL check whether the collation version has changed after upgrading the major PostgreSQL version?
• How do I access logs and generated scripts after upgrading the major PostgreSQL version?
• Can a major version upgrade fail?

Do I need to run ANALYZE and/or REINDEX and refresh statistics (pg_stat_user_tables and pg_statistic) manually after upgrading the major PostgreSQL version?Do I need to run ANALYZE and/or REINDEX and refresh statistics (pg_stat_user_tables and pg_statistic) manually after upgrading the major PostgreSQL version?

You do not need to run ANALYZE and/or REINDEX and refresh statistics manually after upgrading the major version. This is done automatically after the upgrade.

Learn more about upgrading the major PostgreSQL version in Managed Service for PostgreSQL.

Does Managed Service for PostgreSQL check that the collation version has changed after upgrading the major PostgreSQL version?Does Managed Service for PostgreSQL check that the collation version has changed after upgrading the major PostgreSQL version?

collation versions do not change when upgrading the major version, so version checks are not performed.

How do I access logs and generated scripts after upgrading the major PostgreSQL version?How do I access logs and generated scripts after upgrading the major PostgreSQL version?

The process logs are not available to users. If a preliminary check (--check) or an upgrade fails, the necessary details are displayed in an error message.

Can a major version upgrade fail?Can a major version upgrade fail?

An upgrade may fail due to conflicts in the data schema, incompatibility of extensions, or stored procedures. The specific reason is shown in the error message.