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> <CAH2i4yc9o6wVoA4Bc07YxaH4=FKkhLJYHXOUqWsupO1uLEKJFg@mail.gmail.com>
 <011a5254-4abb-460b-bd02-92e8dfc0e5ea@aklaver.com> <CAH2i4yeB3LR0xoNVg5=9c3CaBN3MgA5GTqDSk155e6fvD+a7FA@mail.gmail.com>
 <9cc12221-ba75-4ba0-803f-51be5c8f1525@aklaver.com> <CAH2i4yde0Y1Xjqw8PgexiqyB7nqD51JWQF-i+RUVmmsZattB2g@mail.gmail.com>
 <4c21a115-ec58-4e79-86b8-8626bd307e02@aklaver.com>
In-Reply-To: <4c21a115-ec58-4e79-86b8-8626bd307e02@aklaver.com>
From: =?UTF-8?B?RXJ0YW4gS8O8w6fDvGtvZ2x1?= <ertan.kucukoglu@gmail.com>
Date: Mon, 22 Jul 2024 20:51:30 +0300
Message-ID: <CAH2i4ydwvth001buCV662cd8iMR1RdKMYPBuziTh08aHhuE06w@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="0000000000008d7fbf061dd9b237"
Archived-At: <https://www.postgresql.org/message-id/CAH2i4ydwvth001buCV662cd8iMR1RdKMYPBuziTh08aHhuE06w%40mail.gmail.com>
Precedence: bulk

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

Adrian Klaver <adrian.klaver@aklaver.com>, 22 Tem 2024 Pzt, 20:37 tarihinde
=C5=9Funu yazd=C4=B1:

> What is the command you use to restore the pg_dumpall file?
>

within psql I run \i <dump_file_name>

template1 should not be dropped in the pg_dumpall file.
>
> Is there output that shows that happening?
>

--
-- Databases
--

--
-- Database "template1" dump
--

--
-- PostgreSQL database dump
--

-- Dumped from database version 16.3
-- Dumped by pg_dump version 16.3

SET statement_timeout =3D 0;
SET lock_timeout =3D 0;
SET idle_in_transaction_session_timeout =3D 0;
SET client_encoding =3D 'UTF8';
SET standard_conforming_strings =3D on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies =3D false;
SET xmloption =3D content;
SET client_min_messages =3D warning;
SET row_security =3D off;

UPDATE pg_catalog.pg_database SET datistemplate =3D false WHERE datname =3D
'template1';
DROP DATABASE template1;
--
-- Name: template1; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE template1 WITH TEMPLATE =3D template0 ENCODING =3D 'UTF8'
LOCALE_PROVIDER =3D libc LOCALE =3D 'Turkish_Turkey.1254';

Above lines are taken from the dump file itself and it does indeed drop the
template1. I think this is because this is a cluster dump.
Later it tries to create a new template1 and that command causes an error
because of Windows locale name.


> Was template1 dropped in the Windows Postgres instance?
>

No. It still is there.

BTW dump is taken using the below command line on Windows system.
"C:\Program Files\PostgreSQL\16\bin\pg_dumpall.exe" -U postgres -h
127.0.0.1 -p 5432 -c -f "c:\yedek\cluster.dump.sql"

Thanks & Regards,
Ertan

--0000000000008d7fbf061dd9b237
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;, 22 Tem 2024 Pzt, 2=
0:37 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">What is the command you use=
 to restore the pg_dumpall file?<br></blockquote><div><br></div><div>within=
 psql I run \i &lt;dump_file_name&gt;=C2=A0</div><div><br></div><blockquote=
 class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px so=
lid rgb(204,204,204);padding-left:1ex">
template1 should not be dropped in the pg_dumpall file.<br>
<br>
Is there output that shows that happening?<br></blockquote><div><br></div>-=
-<br>-- Databases<br>--<br><br>--<br>-- Database &quot;template1&quot; dump=
<br>--<br><br>--<br>-- PostgreSQL database dump<br>--<br><br>-- Dumped from=
 database version 16.3<br>-- Dumped by pg_dump version 16.3<br><br>SET stat=
ement_timeout =3D 0;<br>SET lock_timeout =3D 0;<br>SET idle_in_transaction_=
session_timeout =3D 0;<br>SET client_encoding =3D &#39;UTF8&#39;;<br>SET st=
andard_conforming_strings =3D on;<br>SELECT pg_catalog.set_config(&#39;sear=
ch_path&#39;, &#39;&#39;, false);<br>SET check_function_bodies =3D false;<b=
r>SET xmloption =3D content;<br>SET client_min_messages =3D warning;<br>SET=
 row_security =3D off;<br><br>UPDATE pg_catalog.pg_database SET datistempla=
te =3D false WHERE datname =3D &#39;template1&#39;;<br>DROP DATABASE templa=
te1;<br>--<br>-- Name: template1; Type: DATABASE; Schema: -; Owner: postgre=
s<br>--<br><br>CREATE DATABASE template1 WITH TEMPLATE =3D template0 ENCODI=
NG =3D &#39;UTF8&#39; LOCALE_PROVIDER =3D libc LOCALE =3D &#39;Turkish_Turk=
ey.1254&#39;;<br><div><br></div><div>Above lines are taken from the dump fi=
le itself and it does indeed drop the template1. I think this is because th=
is is a cluster dump.</div><div>Later it tries to create a new template1 an=
d that command causes an error because of Windows locale name.</div><div><b=
r></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex=
;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
Was template1 dropped in the Windows Postgres instance?<br></blockquote><di=
v><br></div><div>No. It still is there.</div><div><br></div><div>BTW dump i=
s taken using the below command line on Windows system.</div><div>&quot;C:\=
Program Files\PostgreSQL\16\bin\pg_dumpall.exe&quot; -U postgres -h 127.0.0=
.1 -p 5432 -c -f &quot;c:\yedek\cluster.dump.sql&quot;<br></div><div><br></=
div><div>Thanks &amp; Regards,</div><div>Ertan</div></div></div>

--0000000000008d7fbf061dd9b237--