public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ertan Küçükoglu <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: [email protected]
Subject: Re: Windows installation problem at post-install step
Date: Mon, 22 Jul 2024 20:51:30 +0300
Message-ID: <CAH2i4ydwvth001buCV662cd8iMR1RdKMYPBuziTh08aHhuE06w@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
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>
<[email protected]>
Adrian Klaver <[email protected]>, 22 Tem 2024 Pzt, 20:37 tarihinde
şunu yazdı:
> What is the command you use to restore the pg_dumpall file?
>
within psql I run \i <dump_file_name>
template1 should not be dropped in the pg_dumpall file.
>
> Is there output that shows that happening?
>
--
-- Databases
--
--
-- Database "template1" dump
--
--
-- PostgreSQL database dump
--
-- Dumped from database version 16.3
-- Dumped by pg_dump version 16.3
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
UPDATE pg_catalog.pg_database SET datistemplate = false WHERE datname =
'template1';
DROP DATABASE template1;
--
-- Name: template1; Type: DATABASE; Schema: -; Owner: postgres
--
CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UTF8'
LOCALE_PROVIDER = libc LOCALE = 'Turkish_Turkey.1254';
Above lines are taken from the dump file itself and it does indeed drop the
template1. I think this is because this is a cluster dump.
Later it tries to create a new template1 and that command causes an error
because of Windows locale name.
> Was template1 dropped in the Windows Postgres instance?
>
No. It still is there.
BTW dump is taken using the below command line on Windows system.
"C:\Program Files\PostgreSQL\16\bin\pg_dumpall.exe" -U postgres -h
127.0.0.1 -p 5432 -c -f "c:\yedek\cluster.dump.sql"
Thanks & Regards,
Ertan
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: <CAH2i4ydwvth001buCV662cd8iMR1RdKMYPBuziTh08aHhuE06w@mail.gmail.com>
* 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