Re: Windows installation problem at post-install step

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