- Mais recentes
- Mais votos
- Mais comentários
Perform the upgrade in multiple steps, upgrading to each intermediate version (11 to 11.x to 12.x etc). This will allow the precheck to catch any incompatible objects at each step.
Check for tables declared WITH OIDS by running SELECT table_name FROM information_schema.tables WHERE table_type='BASE TABLE' AND table_catalog='your_database' AND table_schema NOT IN ('pg_catalog', 'information_schema') AND oid_is_present IS TRUE; . Drop any tables returned.
Try upgrading just the data directories and binaries instead of the whole instance. Make a backup, upgrade the data directories on a test server, then restore the backup to a new upgraded instance.
Check the upgrade logs for any errors. The precheck log may provide more details on what objects are blocking the upgrade.
Consider contacting AWS Support for assistance in troubleshooting upgrade issues, as they may have tools or workarounds to help resolve incompatible objects.
Conteúdo relevante
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 anos