[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ezjail] ezjail - Postgresql - Shared Memory

Hi Thomas.

Yes i have read about this too in FreeBSD Diary and i am only gonna use this for test purpose in 1 jail, i do not use pgsql that much at all :) It is only for testing out Gnuworld again since it is about 6 years ago last time, seems it gave me challenges but i am managing them now :)

Phillip you are correct about that Matt Simerson wrote about that solution you gave, but it wasn't that much detailed as your description was that did work out.



-----Original Message----- From: Thomas Steen Rasmussen
Sent: Saturday, October 06, 2012 4:17 AM
To: ezjail AT erdgeist DOT org
Subject: Re: [ezjail] ezjail - Postgresql - Shared Memory

On 05-10-2012 20:49, Dante Peter Lee wrote:

Thanks it worked with removing JAILNAME in rc.conf file and running
that sysctl -w command :)


Just wanted to say that apart from the sysctl tuning suggested on the
FreeBSD Diary and other places, you will also need to change the
default uid of the pgsql user if you are running postgresql server
in 2 or more jails on the same server. Changing uid avoids
the postgresql instances corrupting eachothers shared memory
because the uid is no longer the same. Not pretty, but it works fine :)

Best regards,

Thomas Steen Rasmussen

ps. Please start a new thread next time :) Just create a new mail
to ezjail AT erdgeist DOT org instead of replying to an existing mail in an
unrelated thread :)