template database "template1" has a collation version, but no actual collation version could be determined

Asked Mar 15 '23 at 14:34

Active Mar 16 '23 at 02:40

Viewed 2,455 times

I just upgraded my Postgres from 12 to 15 and I keep getting this error: template database "template1" has a collation version, but no actual collation version could be determined

Here's the template1 collation info in Postgres 15:

Any ideas on how to fix this? Please let me know if any more information is required.

Thanks!

UPDATE:

Here's the OS information:
Distributor ID: Debian.
Description: Debian GNU/Linux 10 (buster).
Release: 10.
Codename: buster.

I have a Postgres docker container so I used this to upgrade: https://github.com/tianon/docker-postgres-upgrade/tree/master/12-to-15

I did not change machines or do an OS upgrade. Here's the template1 collation info on PG 12:

UPDATE 2:

So I did some digging and it turns out that the en_US.utf8 collation does not exist in the pg_collation table on Postgres 12. However on Postgres 15, it does exist in that table and has a version of 2.31:

Is there any way to fix this?

edited Mar 16 '23 at 02:40

asked Mar 15 '23 at 14:34

buddy2891

To your question add the answers to 1) OS and version. 2) How did you upgrade? 3) Did you change machines or do an OS upgrade? 4) What is/was the template1 information for the 12 instance? – Adrian Klaver Mar 15 '23 at 15:54
4

Try `ALTER DATABASE template1 REFRESH COLLATION VERSION;` – Mar 15 '23 at 16:41
1

And rebuild any indexes you created in `template1`. – Laurenz Albe Mar 15 '23 at 16:46
@AdrianKlaver I've updated with additional info – buddy2891 Mar 15 '23 at 17:01
1

@a_horse_with_no_name I tried that but I got an error: ERROR: invalid collation version change – buddy2891 Mar 15 '23 at 17:02
@LaurenzAlbe I don't have any indexes in template1 – buddy2891 Mar 15 '23 at 17:02
Then you don't have to worry about that. – Laurenz Albe Mar 15 '23 at 17:20
I don't know Docker well enough, but my suspicion is that it might have something to do with `FROM postgres:15-bullseye` in the `Dockerfile`. – Adrian Klaver Mar 15 '23 at 17:39
I did some investigating and have updated the original post. – buddy2891 Mar 16 '23 at 02:41
@buddy2891 I saw this in a very similar situation, using the alpine image for pg 15. Switching to the debain (and libc) version made this problem go away for me. If you're showing a "locale provider" of libc under alpine, that's amost certainly wrong. – Keith Layne Mar 16 '23 at 16:20

template database "template1" has a collation version, but no actual collation version could be determined

0 Answers0