| From: | Franz Xaver <drummelbummel(at)hotmail(dot)com> |
|---|---|
| To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Default Sort order Problem - Newbie ;-) |
| Date: | 2022-11-23 11:44:17 |
| Message-ID: | PA4PR07MB72006EBBD00260CD706DB221BB0C9@PA4PR07MB7200.eurprd07.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Here’s what i did to solve the Problem:
sudo -u postgres psql postgres
postgres=> \list
List of databases
Name | Owner | Encoding | Collate | Ctype | ICU Locale | Locale Provider | Access privileges
-----------+----------+----------+-------------+-------------+------------+-----------------+-----------------------
postgres | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | | libc |
template0 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | | libc | =c/postgres +
| | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 | | libc | =c/postgres +
| | | | | | | postgres=CTc/postgres
postgres=# ALTER DATABASE postgres REFRESH COLLATION VERSION;
HINWEIS: Version wird von 2.35 in 2.36 geändert
ALTER DATABASE
postgres=# ALTER DATABASE template0 REFRESH COLLATION VERSION;
FEHLER: invalid collation version change
postgres=# ALTER DATABASE template1 REFRESH COLLATION VERSION;
HINWEIS: Version wird von 2.35 in 2.36 geändert
ALTER DATABASE
postgres=# exit
What was the error?
I did not work on the right database.
Thx again for bringing me on the Right path.
PWO
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Jakobs | 2022-11-23 12:41:39 | postgres (superuser) cannot connect to database |
| Previous Message | Franz Xaver | 2022-11-23 09:08:36 | AW: Default Sort order Problem - Newbie ;-) |