Re: Windows installation problem at post-install step

On 7/22/24 10:09 AM, Ertan Küçükoglu wrote:
> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com