MIME-Version: 1.0
References: <CAH2i4ydECHZPxEBB7gtRG3vROv7a0d3tqAFXzcJWQ9hRsc1znQ@mail.gmail.com>
 <80c9b0ea-c874-40ad-a006-fb1eb37464c2@aklaver.com> <CAH2i4yfkH7YPoLz1aE6MQiBOm8dra5uOTpn51=9ce_Tm6fy3Pw@mail.gmail.com>
 <a9c619c4-f681-4e28-b1d0-cb4845e06fe8@aklaver.com> <CAH2i4ycV8p_uDsdGRcP3bWcU52ogojg9_-mT8uMixSqpNmW7Sg@mail.gmail.com>
 <d55c35b9-a658-4961-849e-871e7dd23fe9@aklaver.com> <CAH2i4yfBEYmOzsvsT=D+ySpLpsEW2O1VfUwx9Ckd69du67YY_w@mail.gmail.com>
 <44b44ece-dce6-4b4f-b751-8787a5a071e0@aklaver.com>
In-Reply-To: <44b44ece-dce6-4b4f-b751-8787a5a071e0@aklaver.com>
From: =?UTF-8?B?RXJ0YW4gS8O8w6fDvGtvZ2x1?= <ertan.kucukoglu@gmail.com>
Date: Mon, 22 Jul 2024 13:10:24 +0300
Message-ID: <CAH2i4yc9o6wVoA4Bc07YxaH4=FKkhLJYHXOUqWsupO1uLEKJFg@mail.gmail.com>
Subject: Re: Windows installation problem at post-install step
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000833b16061dd34118"
Archived-At: <https://www.postgresql.org/message-id/CAH2i4yc9o6wVoA4Bc07YxaH4%3DFKkhLJYHXOUqWsupO1uLEKJFg%40mail.gmail.com>
Precedence: bulk

--000000000000833b16061dd34118
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Adrian Klaver <adrian.klaver@aklaver.com>, 21 Tem 2024 Paz, 22:29 tarihinde
=C5=9Funu yazd=C4=B1:

> 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

--000000000000833b16061dd34118
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Adrian Klaver &lt;<a href=3D"mailto:adria=
n.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&gt;, 21 Tem 2024 Paz, 2=
2:29 tarihinde =C5=9Funu yazd=C4=B1:<br></div><div class=3D"gmail_quote"><b=
lockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-le=
ft:1px solid rgb(204,204,204);padding-left:1ex">If the backup was done usin=
g pg_dump it should work. If you are talking <br>
about a file level backup then it would not work.<br></blockquote><div><br>=
</div><div>Backup file is from a cluster backup taken using pg_dumpall.</di=
v><div>When I try to restore it on Linux, I get below errors</div><div><br>=
</div><div><font face=3D"monospace">psql:/cluster.dump.sql:88: ERROR: =C2=
=A0database &quot;template1&quot; does not exist<br>psql:/cluster.dump.sql:=
93: ERROR: =C2=A0invalid LC_COLLATE locale name: &quot;Turkish_Turkey.1254&=
quot;<br>HINT: =C2=A0If the locale name is specific to ICU, use ICU_LOCALE.=
<br>psql:/cluster.dump.sql:96: ERROR: =C2=A0database &quot;template1&quot; =
does not exist<br>psql:/cluster.dump.sql:98: error: \connect: connection to=
 server on socket &quot;/var/run/postgresql/.s.PGSQL.5432&quot; failed: FAT=
AL: =C2=A0database &quot;template1&quot; does not exist<br></font></div><di=
v><br></div><div>I am not sure if there is a way to change the locale on re=
store.</div><div>I am not sure about the &quot;database &quot;template1&quo=
t; does=C2=A0not exist&quot; error either. Maybe it is because the locale i=
s missing.</div><div><br></div><div>Thanks &amp;=C2=A0Regards,</div><div>Er=
tan</div></div></div>

--000000000000833b16061dd34118--