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

[Andrey Kostin]

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
>