food-rescue-robot icon indicating copy to clipboard operation
food-rescue-robot copied to clipboard

Published 20 hours ago • verified publisher icon boulder-food-rescue

Monkey Patch Postgres to fix Panic string issue.

Open rylanb opened this issue 3 years ago • 3 comments

Overview

Heroku upgraded our Postgres version today via regular maintenance (12-10-2020) and it brought down with a message PG::InvalidParameterValue: ERROR: invalid value for parameter “client_min_messages”: “panic”

Found a way to monkey patch and get the app back up via: https://stackoverflow.com/questions/58763542/pginvalidparametervalue-error-invalid-value-for-parameter-client-min-messag

I think a better option would to re-provision to postgres 9.6 specifically. I couldn't check the version this AM, but best guess is that we are on 10 or 11 version that dropped the support for 'panic'. I don't have a ton of knowledge about this as of now

rylanb avatar Dec 10 '20 16:12 rylanb