So, yes, if you're running multi-tenant Postgres as a public service, you should upgrade. Everyone else is in no rush.
Yes, the application above it should prevent SQL injection, but if it's imperfect, you don't want an attacker to turn SQL injection into RCE.