postgres - cannot create collation

Question

I have a postgres 9.2 database running on debian wheezy. If I execute in pgadmin:

CREATE COLLATION en ( LOCALE = 'en_US.UTF-8')

I get the following error message.

ERROR:  could not create locale "en_US.UTF-8": Datei oder Verzeichnis nicht gefunden
DETAIL:  The operating system could not find any locale data for the locale name "en_US.UTF-8".

I already configured locals on that machine and restarted postgres:

locale-gen en_US.UTF-8
Generating locales (this might take a while)...
  de_DE.UTF-8... done
  en_US.UTF-8... done
  fr_FR.UTF-8... done
  tr_TR.UTF-8... done

But the error is still there. Is there anything else I need to check?

you may need to restart the postgres service

iesen
– iesen

2020-11-16 21:40:45 +00:00
Commented Nov 16, 2020 at 21:40 — iesen
– iesen, Commented Nov 16, 2020 at 21:40

Chris Travers · Accepted Answer · 2013-11-29 06:23:13Z

1

Your basic problem is that PostgreSQL uses operating system locales and collation orders.

On Debian, you need to run the following to add the locale:

dpkg-reconfigure locales

Then once en_US.UTF-8 is there it should work.

answered Nov 29, 2013 at 6:23

Chris Travers

26.6k6 gold badges70 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgres - cannot create collation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related