From: "Sebastian Reitenbach" <sebastia@l00-bugdead-prods.de>
Subject: Re: Update: PostgreSQL 16.4 --  initdb fails for me
To: "Jeremy Evans" <jeremy@openbsd.org>
Cc: "OpenBSD ports" <ports@openbsd.org>
Date: Wed, 28 Aug 2024 12:23:04 +0200

Hi,

On Thursday, August 08, 2024 16:40 CEST, Jeremy Evans <jeremy@openbsd.org> wrote:

> This updates PostgreSQL to the latest release.  Release announcement at:
> https://www.postgresql.org/about/news/postgresql-164-158-1413-1316-1220-and-17-beta-3-released-2910/
> 
> Fixes CVE-2024-7348: PostgreSQL relation replacement during pg_dump
> executes arbitrary SQL
> 
> Tested briefly on amd64.  I'll be doing some additional testing, and
> will be committing in a couple days unless I hear objections.
> 
> As this fixes a CVE, I will be backporting this to -stable.
> 
> Thanks,
> Jeremy

I just tried to re-create one of my systems, which apparently runs postgres.
don't know which version was the last before, where it "just worked", but it's the same way I usually run it
via Puppet:

It fails for me to:

/usr/local/bin/initdb --pgdata '/var/postgresql/data'                                        
The files belonging to this database system will be owned by user "_postgresql".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Europe/Berlin
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... 2024-08-28 09:53:04.861 CEST [60355] FATAL:  text search configuration "french" does not exist
2024-08-28 09:53:04.861 CEST [60355] STATEMENT:  ALTER TEXT SEARCH CONFIGURATION french ADD MAPPING
            FOR word, hword_part, hword
                WITH french_stem;
        /*
         * text search configuration for german language
         *
         * Copyright (c) 2007-2023, PostgreSQL Global Development Group
         *
         * src/backend/snowball/snowball.sql.in
         *
         * german and certain other macros are replaced for each language;
         * see the Makefile for details.
         *
         * Note: this file is read in single-user -j mode, which means that the
         * command terminator is semicolon-newline-newline; whenever the backend
         * sees that, it stops and executes what it's got.  If you write a lot of
         * statements without empty lines between, they'll all get quoted to you
         * in any error message about one of them, so don't do that.  Also, you
         * cannot write a semicolon immediately followed by an empty line in a
         * string literal (including a function body!) or a multiline comment.
         */

        CREATE TEXT SEARCH DICTIONARY german_stem
                (TEMPLATE = snowball, Language = german , StopWords=german);

child process exited with exit code 1
initdb: removing contents of data directory "/var/postgresql/data"