[stork-users] Postgres issues with new install on Rocky8

[Darren Ankney]

Hi Andrey,

This is a known issue as well:
https://gitlab.isc.org/isc-projects/stork/-/issues/932

I believe you'll find a workaround there.  You can also follow the
instructions here: https://kb.isc.org/docs/stork-quickstart-guide for
installing the Stork agent in various Linux distros.

Thank you,

Darren Ankney

On Fri, Oct 6, 2023 at 4:42 PM Andrey Kostin <ankost at podolsk.ru> wrote:
>
> Thank you, Slawek, for quick response.
> After downgrading postgres to version 15, the server is running.
>
> Another question that came up: for stork-agent installation there should
> be script stork-install-agent.sh but I can't find a file with this name
> in the system. Is it created dynamically on request?
>
> Kind regards,
> Andrey
>
>
> Slawek Figiel писал(а) 2023-10-06 04:02:
> > Hello Andrey!
> >
> > Thanks for your report! I have good news. The described problems have
> > already been fixed, and they are waiting for release.
> >
> > Postgres team introduced some breaking-compatibility changes in the
> > last releases. In Postgres 14, they modified the default permissions
> > of the public schema, as you mentioned. We assumed these permissions
> > are always granted. In Postgres 16, they introduced a new
> > "SYSTEM_USER" keyword. Unfortunately, one of the Stork tables is
> > called the same. It broke some essential queries, and Stork could not
> > initialize the database and log users.
> >
> > The above problems were described and solved in
> > https://gitlab.isc.org/isc-projects/stork/-/issues/1148. The fix will
> > be included in next week's release.
> >
> > If you need to set up Stork before the release date, the only
> > workaround is to downgrade Postgres.
> >
> > Best regards
> > Slawek
> >
> --
> Stork-users mailing list
> Stork-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/stork-users