public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Ertan Küçükoglu <[email protected]>
Cc: [email protected]
Subject: Re: Windows installation problem at post-install step
Date: Mon, 22 Jul 2024 10:37:45 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAH2i4yde0Y1Xjqw8PgexiqyB7nqD51JWQF-i+RUVmmsZattB2g@mail.gmail.com>
References: <CAH2i4ydECHZPxEBB7gtRG3vROv7a0d3tqAFXzcJWQ9hRsc1znQ@mail.gmail.com>
<[email protected]>
<CAH2i4yfkH7YPoLz1aE6MQiBOm8dra5uOTpn51=9ce_Tm6fy3Pw@mail.gmail.com>
<[email protected]>
<CAH2i4ycV8p_uDsdGRcP3bWcU52ogojg9_-mT8uMixSqpNmW7Sg@mail.gmail.com>
<[email protected]>
<CAH2i4yfBEYmOzsvsT=D+ySpLpsEW2O1VfUwx9Ckd69du67YY_w@mail.gmail.com>
<[email protected]>
<CAH2i4yc9o6wVoA4Bc07YxaH4=FKkhLJYHXOUqWsupO1uLEKJFg@mail.gmail.com>
<[email protected]>
<CAH2i4yeB3LR0xoNVg5=9c3CaBN3MgA5GTqDSk155e6fvD+a7FA@mail.gmail.com>
<[email protected]>
<CAH2i4yde0Y1Xjqw8PgexiqyB7nqD51JWQF-i+RUVmmsZattB2g@mail.gmail.com>
On 7/22/24 10:09 AM, Ertan Küçükoglu wrote:
> Adrian Klaver <[email protected]
> <mailto:[email protected]>>, 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
[email protected]
view thread (12+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Windows installation problem at post-install step
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox