Feedback-ID: i76984098:Fastmail
Message-ID: <011a5254-4abb-460b-bd02-92e8dfc0e5ea@aklaver.com>
Date: Mon, 22 Jul 2024 07:49:33 -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>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAH2i4yc9o6wVoA4Bc07YxaH4=FKkhLJYHXOUqWsupO1uLEKJFg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/011a5254-4abb-460b-bd02-92e8dfc0e5ea%40aklaver.com>
Precedence: bulk

On 7/22/24 03:10, Ertan Küçükoglu wrote:
> Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.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.

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@aklaver.com