Adrian Klaver <adrian.klaver@xxxxxxxxxxx>, 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
