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

Why is it important to check for invalid indexes before using pg_upgrade?

They are automatically dropped during the upgrade.

They may lead to data loss during the upgrade.

Invalid indexes can cause the upgrade to fail.

They increase the time required for the upgrade.

None

Invalid indexes can cause pg_upgrade to fail, so they should be identified and addressed before proceeding.

What is a potential risk of using link mode in pg_upgrade?

Loss of database logs.

Increased upgrade time.

Inability to revert to the old cluster.

Data corruption in the new cluster.

None

Link mode modifies the original data files, making it impossible to revert to the old cluster without a backup.

Loading questions...

Click Submit to see your final score!

Time's up

Scroll to Top