Feedback-ID: i76984098:Fastmail
Message-ID: <34aefaae-7c57-4593-af82-8c83eb31f3ec@aklaver.com>
Date: Mon, 22 Jul 2024 11:10:06 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Windows installation problem at post-install step
To: =?UTF-8?B?RXJ0YW4gS8O8w6fDvGtvZ2x1?= <ertan.kucukoglu@gmail.com>
Cc: pgsql-general@lists.postgresql.org
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>
 <CAH2i4ydwvth001buCV662cd8iMR1RdKMYPBuziTh08aHhuE06w@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAH2i4ydwvth001buCV662cd8iMR1RdKMYPBuziTh08aHhuE06w@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/34aefaae-7c57-4593-af82-8c83eb31f3ec%40aklaver.com>
Precedence: bulk


On 7/22/24 10:51 AM, Ertan Küçükoglu wrote:
> Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>>, 22 Tem 2024 Pzt, 20:37 tarihinde 
> şunu yazdı:
> 
>     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 = 0;
> SET lock_timeout = 0;
> SET idle_in_transaction_session_timeout = 0;
> SET client_encoding = 'UTF8';
> SET standard_conforming_strings = on;
> SELECT pg_catalog.set_config('search_path', '', false);
> SET check_function_bodies = false;
> SET xmloption = content;
> SET client_min_messages = warning;
> SET row_security = off;
> 
> UPDATE pg_catalog.pg_database SET datistemplate = false WHERE datname = 
> 'template1';
> DROP DATABASE template1;
> --
> -- Name: template1; Type: DATABASE; Schema: -; Owner: postgres
> --
> 
> CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UTF8' 
> LOCALE_PROVIDER = libc LOCALE = '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.

It is because you specified -c to the pg_dumpall command. This cleans 
the database you are restoring to by dropping the existing databases, 
roles and tablespaces before restoring the objects in the file

I am getting out of my depth here, but I am pretty sure that:

ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'Turkish_Turkey.1254'

is not going to work. That you will need to change the locale to a 
Turkish UTF8 name.

> 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

-- 
Adrian Klaver
adrian.klaver@aklaver.com