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 best practice when using pg_upgrade? Upgrade directly from any older version to the latest version. Review release notes for deprecated features. Disable all user roles before upgrading. Ensure both clusters use the same data directory. None 1 out of 20 2. Which of the following is a limitation of pg_upgrade? It cannot handle databases with foreign keys. It cannot upgrade databases larger than 1TB. It requires downtime during the upgrade process. It does not support upgrading from PostgreSQL 9.0 or earlier. 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 up
