My server is in pending mode and i cannot access the db no more

2026-02-02 09:10:08 UTC+7 [491678]: LOG: PID 491676 in cancel request did not match any process oom_guard [402561]: src/oom_guard.c:166:can_allocate() attempting to reclaim memory to allow the allocation (memory usage 287573784 bytes and allocation of 16432 bytes)

2026-02-02 09:10:08 UTC+7 [491676]: STATEMENT: SELECT name, installed_version, default_version, coalesce(array_agg(version ORDER BY version DESC) FILTER (WHERE version IS NOT NULL), ‘{}’) AS available FROM unnest($1::text[]) WITH ORDINALITY AS _(name, idx) LEFT JOIN pg_available_extensions USING (name) LEFT JOIN pg_available_extension_versions USING (name) GROUP BY name, idx, default_version, installed_version ORDER BY idx oom_guard [491676]: src/oom_guard.c:166:can_allocate() attempting to reclaim memory to allow the allocation (memory usage 281880136 bytes and allocation of 53 bytes) oom_guard [491676]: src/oom_guard.c:216:malloc() oom_guard has blocked an allocation oom_guard [491676]: src/oom_guard.c:166:can_allocate() attempting to reclaim memory to allow the allocation (memory usage 281880136 bytes and allocation of 5 bytes) oom_guard [491676]: src/oom_guard.c:216:malloc() oom_guard has blocked an allocation oom_guard [491676]: src/oom_guard.c:166:can_allocate() attempting to reclaim memory to allow the allocation (memory usage 281880136 bytes and allocation of 46 bytes) oom_guard [491676]: src/oom_guard.c:216:malloc() oom_guard has blocked an allocation oom_guard [491676]: src/oom_guard.c:166:can_allocate() attempting to reclaim memory to allow the allocation (memory usage 281880136 bytes and allocation of 5 bytes) oom_guard [491676]: src/oom_guard.c:216:malloc() oom_guard has blocked an allocation

2026-02-02 09:10:08 UTC+7 [491676]: LOG: could not send data to client: Connection reset by peer

2026-02-02 09:10:08 UTC+7 [491676]: ERROR: out of memory

2026-02-02 09:10:08 UTC+7 [491676]: DETAIL: Failed on request of size 32 in memory context “ExprContext”.

2026-02-02 09:10:08 UTC+7 [491676]: LOG: SSL error: malloc failure

2026-02-02 09:10:08 UTC+7 [491676]: STATEMENT: SELECT name, installed_version, default_version, coalesce(array_agg(version ORDER BY version DESC) FILTER (WHERE version IS NOT NULL), ‘{}’) AS available FROM unnest($1::text[]) WITH ORDINALITY AS _(name, idx) LEFT JOIN pg_available_extensions USING (name) LEFT JOIN pg_available_extension_versions USING (name) GROUP BY name, idx, default_version, installed_version ORDER BY idx oom_guard [491676]: src/oom_guard.c:166:can_allocate() attempting to reclaim memory to allow the allocation (memory usage 281234240 bytes and allocation of 53 bytes) oom_guard [491676]: src/oom_guard.c:216:malloc() oom_guard has blocked an allocation oom_guard [491676]: src/oom_guard.c:166:can_allocate() attempting to reclaim memory to allow the allocation (memory usage 281226928 bytes and allocation of 5 bytes) oom_guard [491676]: src/oom_guard.c:216:malloc() oom_guard has blocked an allocation oom_guard [491676]: src/oom_guard.c:166:can_allocate() attempting to reclaim memory to allow the allocation (memory usage 281255360 bytes and allocation of 53 bytes) oom_guard [491676]: src/oom_guard.c:216:malloc() oom_guard has blocked an allocation oom_guard [491676]: src/oom_guard.c:166:can_allocate() attempting to reclaim memory to allow the allocation (memory usage 281256392 bytes and allocation of 5 bytes) oom_guard [491676]: src/oom_guard.c:216:malloc() oom_guard has blocked an allocation

2026-02-02 09:10:08 UTC+7 [491676]: FATAL: connection to client lost oom_guard [491676]: src/oom_guard.c:166:can_allocate() attempting to reclaim memory to allow the allocation (memory usage 281213248 bytes and allocation of 17 bytes) oom_guard [491676]: src/oom_guard.c:216:malloc() oom_guard has blocked an allocation oom_guard [491676]: src/oom_guard.c:166:can_allocate() attempting to reclaim memory to allow the allocation (memory usage 281185848 bytes and allocation of 13 bytes) oom_guard [491676]: src/oom_guard.c:216:malloc() oom_guard has blocked an allocation

I think the RAM is full cuz malloc, so I want to restart the db to reset it, but I cannot restart or resume it (it says it is in the same status)