Re: [ADMIN] FreeBSD SHMMAX
I am trying to get Postgres running on FreeBSD and am running into problems with shared mem. Here is the postgres error messge: On my box the values defined for the kernel are as follow: options SHMMAXPGS=65536 #For postgreSQL options SEMMNI=40 options SEMMNS=240 options SEMUME=40 options SEMMNU=120 If my memory serves me right these values were suggested for PgSQL in FBSD or Postgres documentation. and the corresponding sysctls: kern.ipc.shmmax: 268435456 kern.ipc.shmmin: 1 kern.ipc.shmmni: 192 kern.ipc.shmseg: 128 kern.ipc.shmall: 65536 your kern.ipc.shmall seems a bit low comparing to my setup, maybe the culprit is there. You can tune that sysctl at runtime, try if giving it higher value helps. -Reko ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Postgres user with a shell of /bin/false
I've browsed my history of the list, and the Internet for information regarding giving the unix 'postgres' user a shell of /bin/false, so that it cannot be logged into directly. It seems from my research that if I set the user's shell to /bin/false it will not prevent the running of postgres itself. In at least FreeBSD, the standard ports way of setting PGSQL user to use /usr/bin/nologin as shell works well enough. You get the regular shell interface from SU'ing or sudoing into account, but you cannot login into box directly. Is the nologin "shell" BSD only feature though? -Reko -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
