Upgrades: Old Postgres 9.2 migration instructions seem broken

(bnewbold) #1

While upgrading an old (“ancient” I suppose, though only a couple years back) discourse install, I seem to have run in to a non-trivial database migration problem:

lc_collate cluster values do not match: old "C", new "en_US.UTF-8"

I got a “UPGRADE OF POSTGRES FAILED” message; see the full text in templates/postgres.template.yml#L71 in the discourse/discourse_docker (I can’t post a direct link :frowning:).

However, when I tried to pull @sam’s 0.1.1 samsaffron/discourse docker image, I got an error. Looking on https://hub.docker.com/r/samsaffron/discourse/tags/, I see that the 0.1.1 tag has a size of “0 B” (vs 400 MB+ for most of the other images).

My need isn’t urgent (trivially small, mostly unused installation, and all other, newer discourse containers upgraded smoothly), but thought I should share in case others run in to the same problem. I’ve searched around here on meta for other issues referencing this problem, and don’t see anything since 2014.

(Sam Saffron) #2

Can you do a pg_dump on the database manually and then load it into a clean setup?