Обсуждение: FATAL: cannot request additional shared memory outside shmem_request_hook

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?

Hi

On Fri, Jul 15, 2022 at 6:28 PM Alexander Remus <confabulatus@pm.me> wrote:
>
> 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.

FTR this has already been reported to the project two weeks ago, see
https://github.com/EnterpriseDB/pldebugger/issues/8.

> The question now is: Is there a way to fix this?

Unfortunately the only way is to fix the code, hopefully EDB will take
care it soon.