On Wednesday, August 28, 2024 12:57 CEST, "Sebastian Reitenbach" <sebastia@l00-bugdead-prods.de> wrote:
> 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.
downgraded to 16.3, same issue. Downgraded further to 16.2, I get a different error message:
$ initdb -D /var/postgresql/data -E UTF8
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 "C".
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 15:29:37.977 CEST [85422] FATAL: syntax error at or near "FOR" at character 5
2024-08-28 15:29:37.977 CEST [85422] STATEMENT: FOR asciiword, hword_asciipart, asciihword
WITH french_stem;
child process exited with exit code 1
initdb: removing contents of data directory "/var/postgresql/data"
>
> Sebastian
>
No comments:
Post a Comment