From: | Ertan Küçükoglu <ertan(dot)kucukoglu(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Windows installation problem at post-install step |
Date: | 2024-07-22 10:10:24 |
Message-ID: | CAH2i4yc9o6wVoA4Bc07YxaH4=FKkhLJYHXOUqWsupO1uLEKJFg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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
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
From | Date | Subject | |
---|---|---|---|
Next Message | José María Terry Jiménez | 2024-07-22 10:35:34 | repomd.xml.asc missing in some Fedora 40 repos |
Previous Message | khan Affan | 2024-07-22 10:04:51 | Re: Regarding publish_via_partiton_root with pglogical |