PostgreSQL Version Upgrades: pg_upgrade (Link Mode vs. Copy) Quiz

Home › PostgreSQL DBA › PostgreSQL Version Upgrades: pg_upgrade (Link Mode vs. Copy)

🔧 Postgres Database Administration – PostgreSQL Version Upgrades: pg_upgrade (Link Mode vs. Copy)

20 questions · 15 min timer · Explanations included · Free

What is the role of the pg_upgrade utility in PostgreSQL?

To upgrade a PostgreSQL cluster to a new major version.

To migrate data between different database systems.

To upgrade PostgreSQL extensions.

To perform minor version updates.

None

pg_upgrade is specifically designed to upgrade a PostgreSQL cluster to a new major version while preserving data.

How does pg_upgrade handle custom extensions during an upgrade?

It upgrades only official PostgreSQL extensions.

It automatically upgrades all extensions.

It disables extensions during the upgrade.

It ignores extensions, requiring manual intervention.

None

pg_upgrade does not automatically upgrade custom extensions; they must be manually handled to ensure compatibility with the new version.

Loading questions...

Click Submit to see your final score!

Time's up

Scroll to Top