CODEWITHSUNDEEP
databasepostgresql
Andrew Van Den Brink
Andrew Van Den Brink

Reputation: 123

Unable to create memory segment when running 2 instance of Postgresql

The server it self only have azure A0 configuration (750 MB).

I'm trying to run 2 instance of Postgresql. Looks like I'm only able to run one of it on the same time. The second instance always failed to run with "Unable to create memory segment" error. Is there any configuration I can change to mitigate this issue?

PostgreSQL version 9.5

Windows server 2012 datacenter

shared_buffers 128 MB (changed to 64 MB still not working)

Upvotes: 0

Views: 47

Answers (1)

Andrew Van Den Brink
Andrew Van Den Brink

Reputation: 123

I changed the config 

dynamic_shared_memory_type = windows

to

dynamic_shared_memory_type = none

I can run 2 instance in the same time after that.

Upvotes: 2

Related Questions