Re: Windows installation problem at post-install step - Mailing list pgsql-general

From Ertan Küçükoglu
Subject Re: Windows installation problem at post-install step
Date
Msg-id CAH2i4yde0Y1Xjqw8PgexiqyB7nqD51JWQF-i+RUVmmsZattB2g@mail.gmail.com
Whole thread Raw
In response to Re: Windows installation problem at post-install step  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Windows installation problem at post-install step
List pgsql-general
Adrian Klaver <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.
I need to remove postgresql and cluster for good and install back to fix that.

Thanks & Regards,
Ertan

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Windows installation problem at post-install step
Next
From: Adrian Klaver
Date:
Subject: Re: Windows installation problem at post-install step