D
Dokployā€¢6mo ago
just

How edit shm size in postgres db?

I created postgres database service, i cant see where edit shm (shared memory size). I have this issue https://stackoverflow.com/questions/56751565/pq-could-not-resize-shared-memory-segment-no-space-left-on-device and edit shm will help me.
Stack Overflow
pq: could not resize shared memory segment. No space left on device
I have on a dashboard, a number of panels (numbering around 6)to display data points chart making queries to dockerised instance of PostgreSQL database. Panels were working fine until very recently,
No description
6 Replies
just
justOPā€¢6mo ago
help
Siumauricio
Siumauricioā€¢6mo ago
Hmm I think the only way is using docker compose But you will lose the features like backup
just
justOPā€¢5mo ago
Can you add this for app? Please, i use backups up šŸ™šŸæ
just
justOPā€¢5mo ago
just
justOPā€¢3mo ago
up up up
Jon
Jonā€¢2mo ago
Has this issue been addressed yet? seems like it would be worthwhile to allow updating the shm size of dokploy containers. For context, I have a dokploy service installed, 'timescale/timescaledb:2.13.0-pg15' and when accessing the db, I'm getting this: 
2025-04-03 18:16:05.295 UTC [10779] ERROR:  could not resize shared memory segment "/PostgreSQL.4006906430" to 2097152 bytes: No space left on device
2025-04-03 18:16:05.295 UTC [10779] STATEMENT:  SELECT "t0"."id", "t0"."name", "t0"."slug", "t0"."description", "t0"."views", JSONB_BUILD_OBJECT('maps', COALESCE("t2"."_aggr_count_maps", 0)) AS "_count" FROM "public"."tags" AS "t0" LEFT JOIN (SELECT "public"."_MapToTag"."B", COUNT("public"."_MapToTag"."B") AS "orderby_aggregator" FROM "public"."maps" LEFT JOIN "public"."_MapToTag" ON ("public"."maps"."id" = "public"."_MapToTag"."A") WHERE 1=1 GROUP BY "public"."_MapToTag"."B") AS "orderby_1_Map" ON ("t0"."id" = "orderby_1_Map"."B") LEFT JOIN LATERAL (SELECT COUNT(*) AS "_aggr_count_maps" FROM "public"."maps" AS "t3" LEFT JOIN "public"."_MapToTag" AS "t4" ON "t4"."A" = "t3"."id" WHERE "t4"."B" = "t0"."id") AS "t2" ON true WHERE EXISTS(SELECT "t1"."B" FROM "public"."_MapToTag" AS "t1" INNER JOIN "public"."maps" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ("j1"."is_public" = $1 AND "j1"."disabled" = $2 AND "j1"."ratings"::jsonb <> $3 AND "j1"."moderation_status" = $4 AND ("t0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) ORDER BY COALESCE("orderby_1_Map"."orderby_aggregator", $5) DESC
2025-04-03 18:16:05.309 UTC [10969] ERROR:  could not attach to dynamic shared area
2025-04-03 18:16:05.295 UTC [10779] ERROR:  could not resize shared memory segment "/PostgreSQL.4006906430" to 2097152 bytes: No space left on device
2025-04-03 18:16:05.295 UTC [10779] STATEMENT:  SELECT "t0"."id", "t0"."name", "t0"."slug", "t0"."description", "t0"."views", JSONB_BUILD_OBJECT('maps', COALESCE("t2"."_aggr_count_maps", 0)) AS "_count" FROM "public"."tags" AS "t0" LEFT JOIN (SELECT "public"."_MapToTag"."B", COUNT("public"."_MapToTag"."B") AS "orderby_aggregator" FROM "public"."maps" LEFT JOIN "public"."_MapToTag" ON ("public"."maps"."id" = "public"."_MapToTag"."A") WHERE 1=1 GROUP BY "public"."_MapToTag"."B") AS "orderby_1_Map" ON ("t0"."id" = "orderby_1_Map"."B") LEFT JOIN LATERAL (SELECT COUNT(*) AS "_aggr_count_maps" FROM "public"."maps" AS "t3" LEFT JOIN "public"."_MapToTag" AS "t4" ON "t4"."A" = "t3"."id" WHERE "t4"."B" = "t0"."id") AS "t2" ON true WHERE EXISTS(SELECT "t1"."B" FROM "public"."_MapToTag" AS "t1" INNER JOIN "public"."maps" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ("j1"."is_public" = $1 AND "j1"."disabled" = $2 AND "j1"."ratings"::jsonb <> $3 AND "j1"."moderation_status" = $4 AND ("t0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) ORDER BY COALESCE("orderby_1_Map"."orderby_aggregator", $5) DESC
2025-04-03 18:16:05.309 UTC [10969] ERROR:  could not attach to dynamic shared area
I can't see any way, other than pulling this out of dokploy, to modify the shared memory size to allow this to work...

Did you find this page helpful?