On 7/22/24 10:09 AM, Ertan Küçükoglu wrote:
Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>>, 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@xxxxxxxxxxx
