-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Talk about 'old email', but better then 'use different ports', which means you
have to modify your clients for this ... after you install postgresql within
the jail, vipw the password file and change the uid of the pgsql user (and
chown the
You can alternatively set the SEM* and SHMMAX in the loader.conf.
I have a server runing two pgs.
# cat /boot/loader.conf
kern.ipc.semmni=256
kern.ipc.semmns=512
kern.ipc.semmnu=256
kern.ipc.semmap=256
Oliver Fromme wrote:
Oliver Peter wrote:
Oliver Fromme wrote:
Oliver Peter wrote:
On Thu, Oct 25, 2007 at 04:38:53PM +0200, Oliver Fromme wrote:
Oliver Peter wrote:
Oliver Fromme wrote:
Oliver Peter wrote:
...
Can you please give the output from ipcs -M and ipcs -p?
Here you go:
% sudo ipcs -M
shminfo:
shmmax:134217728(max shared memory segment size)
On Fri, Oct 26, 2007 at 11:30:57AM +0300, Anton - Valqk wrote:
You can alternatively set the SEM* and SHMMAX in the loader.conf.
I have a server runing two pgs.
# cat /boot/loader.conf
kern.ipc.semmni=256
kern.ipc.semmns=512
kern.ipc.semmnu=256
kern.ipc.semmap=256
Thanks buddy.
Currently
Oliver Peter wrote:
Oliver Fromme wrote:
Oliver Peter wrote:
Does anybody have a running system with more than one jail hosting
more than one postgres server?
Yes, you must configure them to use different port numbers,
because the SysV IPC IDs are derived from the port
On Tue, Oct 23, 2007 at 10:06:08PM +0200, Oliver Fromme wrote:
Oliver Peter wrote:
Does anybody have a running system with more than one jail hosting
more than one postgres server?
Yes, you must configure them to use different port numbers,
because the SysV IPC IDs are derived from the
Does anybody have a running system with more than one jail hosting
more than one postgres server?
I can only have one pgsql database on one host at all. I already
tried to increase the shared memory off my machine with additional
kernel [1] and sysctl parameters [2] and I also tried to change
Oliver Peter wrote:
Does anybody have a running system with more than one jail hosting
more than one postgres server?
Yes, you must configure them to use different port numbers,
because the SysV IPC IDs are derived from the port number.
If you try to run both servers with the default port,