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 1. Which of the following is a common pitfall when using pg_upgrade in copy mode? Data files are not copied correctly. Insufficient disk space for the new cluster. Incompatibility with third-party extensions. Increased risk of data corruption. None 1 out of 20 2. Which of the following is a best practice when using pg_upgrade? Upgrade directly from any older version to the latest version. Ensure both clusters use the same data directory. Review release notes for deprecated features. Disable all user roles before upgrading. None 2 out of 20 Loading questions... 3 out of 20 Loading questions... 4 out of 20 Loading questions... 5 out of 20 Loading questions... 6 out of 20 Loading questions... 7 out of 20 Loading questions... 8 out of 20 Loading questions... 9 out of 20 Loading questions... 10 out of 20 Loading questions... 11 out of 20 Loading questions... 12 out of 20 Loading questions... 13 out of 20 Loading questions... 14 out of 20 Loading questions... 15 out of 20 Loading questions... 16 out of 20 Loading questions... 17 out of 20 Loading questions... 18 out of 20 Loading questions... 19 out of 20 Loading questions... 20 out of 20 Click Submit to see your final score! Previous Start Quiz Next Time's upTime is Up!