Feedback-ID: i76984098:Fastmail
Message-ID: <4c21a115-ec58-4e79-86b8-8626bd307e02@aklaver.com>
Date: Mon, 22 Jul 2024 10:37:45 -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>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAH2i4yde0Y1Xjqw8PgexiqyB7nqD51JWQF-i+RUVmmsZattB2g@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/4c21a115-ec58-4e79-86b8-8626bd307e02%40aklaver.com>
Precedence: bulk


On 7/22/24 10:09 AM, Ertan Küçükoglu wrote:
> Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>>, 22 Tem 2024 Pzt, 20:04 tarihinde 
> şunu yazdı:
> 
>     When you connect using psql do you see template0, template1 and
>     postgres
>     when you do \l?
> 
> 
> Yes
> postgres=# \l
>                                                         List of databases
>     Name    |  Owner   | Encoding | Locale Provider |   Collate   |   
>   Ctype    | ICU Locale | ICU Rules |   Access privileges
> -----------+----------+----------+-----------------+-------------+-------------+------------+-----------+-----------------------
>   postgres  | postgres | UTF8     | libc            | en_US.UTF-8 | 
> en_US.UTF-8 |            |           |
>   template0 | postgres | UTF8     | libc            | en_US.UTF-8 | 
> en_US.UTF-8 |            |           | =c/postgres          +
>             |          |          |                 |             |     
>          |            |           | postgres=CTc/postgres
>   template1 | postgres | UTF8     | libc            | en_US.UTF-8 | 
> en_US.UTF-8 |            |           | =c/postgres          +
>             |          |          |                 |             |     
>          |            |           | postgres=CTc/postgres
> (3 rows)
> 
>     Does the restore work?
> 
> 
> Restore fails and complaints about the Windows locale name.
> Moreover, it is a cluster backup and restore deletes template1 which 
> breaks psql connection.

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

template1 should not be dropped in the pg_dumpall file.

Is there output that shows that happening?

Was template1 dropped in the Windows Postgres instance?

> I need to remove postgresql and cluster for good and install back to fix 
> that.
> 
> Thanks & Regards,
> Ertan
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com