MARMEI
Help! Prod PostgreSQL crashes suddenly.
The database suddenly started to issue such messages, there were no new commits, the load did not grow before that for 2 months everything worked fine.
Logs:
WHERE generations.tg_id = $1::VARCHAR AND (generations.status = $2::VARCHAR OR generations.status = $3::VARCHAR OR generations.status = $4::VARCHAR OR generations.status = $5::VARCHAR)
2024-07-05 16:32:41.106 UTC [294] ERROR: could not resize shared memory segment "/PostgreSQL.2946584502" to 184928 bytes: No space left on device
5 replies
PostgreSQL Max Connections Limit
Hello, I really need to increase the maximum number of connections to PostgreSQL. I tried different options, through environment variables, through SQL query, through PGbouncer and edited Env in it too, it's like watching the config(SHOW max_connections;) and the console displays a maximum of 100.
8 replies