Hi,
On Wednesday, August 28, 2024 12:23 CEST, "Sebastian Reitenbach" <sebastia@l00-bugdead-prods.de> wrote:
> 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"
on some other host I have a happily running 16.2. Haven't yet spotted the difference.
Sebastian
No comments:
Post a Comment