On 7/22/24 03:10, Ertan Küçükoglu wrote:
Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto: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
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.
Provide the following info:
1) Linux distro and version.
2) How did you install Postgres?
3) Versions of Postgres that was dumped from and restored to.
4) How did you initdb the Postgres cluster?
5) Can you connect to cluster using psql?
Thanks & Regards,
Ertan
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
