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