Re: requiring PostgreSQL superuser

2024-10-13 Thread Christian Grothoff
Hi Daniel, I've removed the LOCK statement, it was there to deal with a rare edge case where the versioning.sql was loaded concurrently, which is bad as the IF NOT EXISTS on the SCHEMA doesn't work without the lock, resulting in a hard failure. AFAIK the rare case where we needed this was reso

requiring PostgreSQL superuser

2024-10-12 Thread Daniel Golle
Hi! I've been playing with recent GNUnet releases and noticed that GNUnet now requirs PostgreSQL super user privileges. This is problematic and GNUnet should be able to run with only a more limited set of PostgreSQL permissions. The reason for that new requirement is LOCK TABLE pg_catalog.pg_name