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. Why is it important to check for invalid indexes before using pg_upgrade? They may lead to data loss during the upgrade. They are automatically dropped during the upgrade. They increase the time required for the upgrade. Invalid indexes can cause the upgrade to fail. None 1 out of 20 2. Which of the following is a critical step before performing a pg_upgrade? Ensure all database connections are active. Increase shared_buffers to maximum. Disable all database logs. Backup the old cluster. 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
