úterý 15. března 2022

Old PostgreSQL 9.4 is not starting

I have on my old external drive some PostgreSQL data directory. What is inside? Lets install old PostgreSQL 9.4 and check it out.

But it is not starting :( In the Event Viewer I have:

2022-03-15 09:05:29 CET LOG:  invalid value for parameter "lc_time": "Czech_Czech Republic.1250"

What to do next? Check this guide - https://dba.stackexchange.com/questions/188837/postgresql-9-5-wont-start-after-windows-10-fall-update

  1. Download https://www.microsoft.com/en-us/download/details.aspx?id=41158
  2. Install it
  3. Run the Locale Builder 
  4. Create new locale with Czech locale (cs-CZ) and cs-CZ
  5. Change the Region name from Czechia to Czech Republic.
  6. In the menu click on: Build - Build Locale Installer
  7. Install the locale
  8. Start your PostgreSQL!