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 07:49:33 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAH2i4yc9o6wVoA4Bc07YxaH4=FKkhLJYHXOUqWsupO1uLEKJFg@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>
On 7/22/24 03:10, Ertan Küçükoglu wrote:
> Adrian Klaver <[email protected]
> <mailto:[email protected]>>, 21 Tem 2024 Paz, 22:29 tarihinde
> şunu yazdı:
>
> If the backup was done using pg_dump it should work. If you are talking
> about a file level backup then it would not work.
>
>
> Backup file is from a cluster backup taken using pg_dumpall.
> When I try to restore it on Linux, I get below errors
>
> psql:/cluster.dump.sql:88: ERROR: database "template1" does not exist
> psql:/cluster.dump.sql:93: ERROR: invalid LC_COLLATE locale name:
> "Turkish_Turkey.1254"
> HINT: If the locale name is specific to ICU, use ICU_LOCALE.
> psql:/cluster.dump.sql:96: ERROR: database "template1" does not exist
> psql:/cluster.dump.sql:98: error: \connect: connection to server on
> socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: database
> "template1" does not exist
>
> I am not sure if there is a way to change the locale on restore.
> I am not sure about the "database "template1" does not exist" error
> either. Maybe it is because the locale is missing.
Provide the following info:
1) Linux distro and version.
2) How did you install Postgres?
3) Versions of Postgres that was dumped from and restored to.
4) How did you initdb the Postgres cluster?
5) Can you connect to cluster using psql?
>
> 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