"Joel Burton" <[EMAIL PROTECTED]> writes: >> This will allow you to run a single postgres in a single jail only one >> user would have access to it. If you try to run more then one it will >> try to use the same shared memory and crash.
> Is this, in fact, the case? Unless BSD jails have very bizarre shared memory behavior, this is nonsense. PG can easily run multiple postmasters in the same machine (there are currently four postmasters of different vintages alive on the machine I'm typing this on). Give each one a different database directory and a unique port number, and you're good to go. It might be that postmasters in different jails on the same machine would have to be assigned different port numbers to keep them from conflicting. Don't know exactly how airtight a BSD jail is ... but there is an interaction between port number and shared memory key. I can imagine that a jail that hides processes but not shared memory segments might confuse our startup logic that tries to detect whether an existing shared memory segment is safe to reuse or not. Perhaps your ISP has seen failures of that type from trying to start multiple postmasters on the same port number in different jails. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])