Adrian Klaver <adrian.kla...@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
