ERROR: could not resize shared memory segment "/PostgreSQL.3215581274" to 1048576 bytes: No space left on device

I am getting this error in Catalina ERROR: could not resize shared memory segment "/PostgreSQL.3215581274" to 1048576 bytes: No space left on device

Please what does it mean? Has anyone experience this and how do you resolve it.

1 Like

It sounds like you might not have space at the location hosting your Postgresql. As an obvious starting point, you might want to check that the location where you host PostgreSQL has space. Then check the configuration for shared_buffers and max_locks_per_transaction to ensure you have the optimal configuration for your system’s available resources.

2 Likes