am being blocked by the fact that there are later jsonb operators that my version doesn't have (such as checking key existence in json). How much pain would be involved in upgrading the system's postgres? Would existing data be safe?
Not only that you get some more JSON features. PostgreSQL 10 is out of support since November 10, 2022. Your database is at risk. To upgrade it, you should read all version changes. Otherwise you might stumble upon a change, that might break your application. And nobody can tell how long the upgrades might take without further knowledge of database size, indexes, hardware etc.
Обсуждают сегодня