Re: Windows installation problem at post-install step
| От | Ertan Küçükoglu |
|---|---|
| Тема | Re: Windows installation problem at post-install step |
| Дата | |
| Msg-id | CAH2i4yc9o6wVoA4Bc07YxaH4=FKkhLJYHXOUqWsupO1uLEKJFg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Windows installation problem at post-install step (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: Windows installation problem at post-install step
|
| Список | pgsql-general |
Adrian Klaver <adrian.klaver@aklaver.com>, 21 Tem 2024 Paz, 22:29 tarihinde şunu yazdı:
If the backup was done using pg_dump it should work. If you are talking
about a file level backup then it would not work.
Backup file is from a cluster backup taken using pg_dumpall.
When I try to restore it on Linux, I get below errors
psql:/cluster.dump.sql:88: ERROR: database "template1" does not exist
psql:/cluster.dump.sql:93: ERROR: invalid LC_COLLATE locale name: "Turkish_Turkey.1254"
HINT: If the locale name is specific to ICU, use ICU_LOCALE.
psql:/cluster.dump.sql:96: ERROR: database "template1" does not exist
psql:/cluster.dump.sql:98: error: \connect: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: database "template1" does not exist
psql:/cluster.dump.sql:93: ERROR: invalid LC_COLLATE locale name: "Turkish_Turkey.1254"
HINT: If the locale name is specific to ICU, use ICU_LOCALE.
psql:/cluster.dump.sql:96: ERROR: database "template1" does not exist
psql:/cluster.dump.sql:98: error: \connect: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: database "template1" does not exist
I am not sure if there is a way to change the locale on restore.
I am not sure about the "database "template1" does not exist" error either. Maybe it is because the locale is missing.
Thanks & Regards,
Ertan
В списке pgsql-general по дате отправления: