Re: Windows installation problem at post-install step

[Ertan Küçükoglu <ertan.kucukoglu@xxxxxxxxx>]

Adrian Klaver <adrian.klaver@xxxxxxxxxxx>, 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.

I need to remove postgresql and cluster for good and install back to fix that.

Thanks & Regards,

Ertan