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>
In-Reply-To: <9cc12221-ba75-4ba0-803f-51be5c8f1525@aklaver.com>
From: =?UTF-8?B?RXJ0YW4gS8O8w6fDvGtvZ2x1?= <ertan.kucukoglu@gmail.com>
Date: Mon, 22 Jul 2024 20:09:23 +0300
Message-ID: <CAH2i4yde0Y1Xjqw8PgexiqyB7nqD51JWQF-i+RUVmmsZattB2g@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="000000000000f5341a061dd91b0f"
Archived-At: <https://www.postgresql.org/message-id/CAH2i4yde0Y1Xjqw8PgexiqyB7nqD51JWQF-i%2BRUVmmsZattB2g%40mail.gmail.com>
Precedence: bulk

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

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

> When you connect using psql do you see template0, template1 and postgres
> when you do \l?
>

Yes

postgres=3D# \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 |            |           | =3Dc/postgres          +
           |          |          |                 |             |
    |            |           | postgres=3DCTc/postgres
 template1 | postgres | UTF8     | libc            | en_US.UTF-8 |
en_US.UTF-8 |            |           | =3Dc/postgres          +
           |          |          |                 |             |
    |            |           | postgres=3DCTc/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.
I need to remove postgresql and cluster for good and install back to fix
that.

Thanks & Regards,
Ertan

--000000000000f5341a061dd91b0f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: base64

PGRpdiBkaXI9Imx0ciI+PGRpdiBkaXI9Imx0ciI+QWRyaWFuIEtsYXZlciAmbHQ7PGEgaHJlZj0i
bWFpbHRvOmFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20iPmFkcmlhbi5rbGF2ZXJAYWtsYXZlci5j
b208L2E+Jmd0OywgMjIgVGVtIDIwMjQgUHp0LCAyMDowNCB0YXJpaGluZGUgxZ91bnUgeWF6ZMSx
Ojxicj48L2Rpdj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+PGJsb2NrcXVvdGUgY2xhc3M9Imdt
YWlsX3F1b3RlIiBzdHlsZT0ibWFyZ2luOjBweCAwcHggMHB4IDAuOGV4O2JvcmRlci1sZWZ0OjFw
eCBzb2xpZCByZ2IoMjA0LDIwNCwyMDQpO3BhZGRpbmctbGVmdDoxZXgiPldoZW4geW91IGNvbm5l
Y3QgdXNpbmcgcHNxbCBkbyB5b3Ugc2VlIHRlbXBsYXRlMCwgdGVtcGxhdGUxIGFuZCBwb3N0Z3Jl
cyA8YnI+DQp3aGVuIHlvdSBkbyBcbD88YnI+PC9ibG9ja3F1b3RlPjxkaXY+PGJyPjwvZGl2Pjxk
aXY+WWVzPC9kaXY+PGRpdj7CoDwvZGl2PnBvc3RncmVzPSMgXGw8YnI+wqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqBMaXN0IG9mIGRhdGFiYXNlczxicj7CoCDCoE5hbWUgwqAgwqB8IMKgT3duZXIg
wqAgfCBFbmNvZGluZyB8IExvY2FsZSBQcm92aWRlciB8IMKgIENvbGxhdGUgwqAgfCDCoCDCoEN0
eXBlIMKgIMKgfCBJQ1UgTG9jYWxlIHwgSUNVIFJ1bGVzIHwgwqAgQWNjZXNzIHByaXZpbGVnZXMg
wqAgPGJyPi0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0t
LSstLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tPGJyPsKgcG9zdGdyZXMgwqB8IHBvc3RncmVzIHwgVVRGOCDC
oCDCoCB8IGxpYmMgwqAgwqAgwqAgwqAgwqAgwqB8IGVuX1VTLlVURi04IHwgZW5fVVMuVVRGLTgg
fCDCoCDCoCDCoCDCoCDCoCDCoHwgwqAgwqAgwqAgwqAgwqAgfCA8YnI+wqB0ZW1wbGF0ZTAgfCBw
b3N0Z3JlcyB8IFVURjggwqAgwqAgfCBsaWJjIMKgIMKgIMKgIMKgIMKgIMKgfCBlbl9VUy5VVEYt
OCB8IGVuX1VTLlVURi04IHwgwqAgwqAgwqAgwqAgwqAgwqB8IMKgIMKgIMKgIMKgIMKgIHwgPWMv
cG9zdGdyZXMgwqAgwqAgwqAgwqAgwqArPGJyPsKgIMKgIMKgIMKgIMKgIMKgfCDCoCDCoCDCoCDC
oCDCoHwgwqAgwqAgwqAgwqAgwqB8IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIHwgwqAgwqAgwqAg
wqAgwqAgwqAgfCDCoCDCoCDCoCDCoCDCoCDCoCB8IMKgIMKgIMKgIMKgIMKgIMKgfCDCoCDCoCDC
oCDCoCDCoCB8IHBvc3RncmVzPUNUYy9wb3N0Z3Jlczxicj7CoHRlbXBsYXRlMSB8IHBvc3RncmVz
IHwgVVRGOCDCoCDCoCB8IGxpYmMgwqAgwqAgwqAgwqAgwqAgwqB8IGVuX1VTLlVURi04IHwgZW5f
VVMuVVRGLTggfCDCoCDCoCDCoCDCoCDCoCDCoHwgwqAgwqAgwqAgwqAgwqAgfCA9Yy9wb3N0Z3Jl
cyDCoCDCoCDCoCDCoCDCoCs8YnI+wqAgwqAgwqAgwqAgwqAgwqB8IMKgIMKgIMKgIMKgIMKgfCDC
oCDCoCDCoCDCoCDCoHwgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgfCDCoCDCoCDCoCDCoCDCoCDC
oCB8IMKgIMKgIMKgIMKgIMKgIMKgIHwgwqAgwqAgwqAgwqAgwqAgwqB8IMKgIMKgIMKgIMKgIMKg
IHwgcG9zdGdyZXM9Q1RjL3Bvc3RncmVzPGJyPigzIHJvd3MpPGJyPjxicj48ZGl2PsKgPC9kaXY+
PGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0ibWFyZ2luOjBweCAwcHggMHB4
IDAuOGV4O2JvcmRlci1sZWZ0OjFweCBzb2xpZCByZ2IoMjA0LDIwNCwyMDQpO3BhZGRpbmctbGVm
dDoxZXgiPg0KRG9lcyB0aGUgcmVzdG9yZSB3b3JrPzxicj48L2Jsb2NrcXVvdGU+PGRpdj7CoDxi
cj48L2Rpdj48ZGl2PlJlc3RvcmUgZmFpbHMgYW5kIGNvbXBsYWludHMgYWJvdXQgdGhlIFdpbmRv
d3MgbG9jYWxlIG5hbWUuPC9kaXY+PGRpdj5Nb3Jlb3ZlciwgaXQgaXMgYSBjbHVzdGVyIGJhY2t1
cCBhbmQgcmVzdG9yZSBkZWxldGVzIHRlbXBsYXRlMSB3aGljaCBicmVha3MgcHNxbCBjb25uZWN0
aW9uLjwvZGl2PjxkaXY+SSBuZWVkIHRvIHJlbW92ZSBwb3N0Z3Jlc3FsIGFuZCBjbHVzdGVyIGZv
ciBnb29kIGFuZCBpbnN0YWxsIGJhY2sgdG8gZml4IHRoYXQuPC9kaXY+PGRpdj48YnI+PC9kaXY+
PGRpdj5UaGFua3MgJmFtcDsgUmVnYXJkcyw8L2Rpdj48ZGl2PkVydGFuPC9kaXY+PGRpdj48YnI+
PC9kaXY+PC9kaXY+PC9kaXY+DQo=
--000000000000f5341a061dd91b0f--