| From: | Torsten Zühlsdorff <foo(at)meisterderspiele(dot)de> |
|---|---|
| To: | amitabhkant(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: InitDB: Bad system call |
| Date: | 2010-08-10 07:26:58 |
| Message-ID: | 4C60FF42.6020905@meisterderspiele.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello Thom,
> See http://www.postgresql.org/docs/9.0/static/kernel-resources.html
> and the section under NetBSD/OpenBSD.
I already know the FreeBSD section. My current values are:
kern.ipc.shmall: 131072
kern.ipc.shmmax: 2684225436
kern.ipc.semmap: 4096
kern.ipc.semmnu: 512
kern.ipc.semmns: 1024
kern.ipc.semmni: 512
kern.ipc.shm_use_phys: 0
security.jail.sysvipc_allowed: 1
I also run the user with different UIDs:
$ grep pgsql -h /usr/local/jail/*/*/etc/passwd
pgsql:*:1070:70:PostgreSQL Daemon:/usr/local/pgsql:/bin/sh
pgsql:*:7575:7575:PostgreSQL Daemon:/usr/local/pgsql:/bin/sh
pgsql:*:1074:70:PostgreSQL Daemon:/usr/local/pgsql:/bin/sh
pgsql:*:1071:70:PostgreSQL Daemon:/usr/local/pgsql:/bin/sh
I also rebuild the complete jail to make sure, that it is not an error
while creating the jail.
I also disable all - but one (the live-db ;)) - postgresql instance to
make sure, that enough shared memory is free.
But the "bad system call" messages don't go away. Any other hint?
Greetings,
Torsten
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Atul.Goel | 2010-08-10 08:39:30 | pl/pgsql editor and postgres developemnt tool |
| Previous Message | Pavel Stehule | 2010-08-10 06:27:48 | Re: RETURN QUERY SELECT & TYPE |