Hello,
I'm trying to get the plugin_debugger plugin to work on a Manjaro system.
I got the source code of Postgres from
https://github.com/postgres/postgres, and the source code of the
extension from git clone https://github.com/EnterpriseDB/pldebugger.git.
The build process went OK and a database has been init.
Now when I shut the the database down and edit the postgresql.conf file
as instructed in https://github.com/EnterpriseDB/pldebugger, the server
cannot be started again due to this error:
FATAL: cannot request additional shared memory outside shmem_request_hook.
I'm sure that the extension built OK since I failed to change the
directory in my build script before and upon server start I got a
different error saying that it cannot find the plugin or something along
those lines.
In https://www.pgadmin.org/docs/pgadmin4/development/debugger.html it
says "You must have superuser privileges to use the debugger.". Not sure
about this, does this refer to the database role? The server is started
with a postgres system account, which is not a "Linux" superuser, at
least I cannot use sudo as this user.
The question now is: Is there a way to fix this?