Gentoo Full Text Bug Listing

Description:

Opened: 2007-08-16 17:41 0000

The FreeBSD kernel has a limit of 60 semaphores out of the box, so postgres
can't have 512 connections out of the box on Gentoo/FreeBSD.

This causes postgresql to fail silently and one must tweak the postgresql
startup file inorder to even get an error message. (remove the
--silent-mode=true part of the startup script).


# sysctl -a|grep -i semmns
kern.ipc.semmns: 60

# diff /etc/conf.d/postgresql.orig /etc/conf.d/postgresql
15c15
< PGOPTS="-N 512 -B 1024"
---
> PGOPTS="-N 40 -B 1024"


Reproducible: Always

------- Comment #1 From Roy Marples (RETIRED) 2007-08-17 15:09:26 0000 -------

Fixed, thanks.

Bug#: 189141	Product: Gentoo/Alt	Version: unspecified	Platform: All
OS/Version: FreeBSD	Status: RESOLVED	Severity: normal	Priority: P2
Resolution: FIXED	Assigned To: bsd@gentoo.org	Reported By: jshupe@gmail.com
Component: FreeBSD
URL:
Summary: postgresql on Gentoo/FreeBSD defaults to 512 connections which is more than the default kernel allows
Keywords:
Status Whiteboard:
Opened: 2007-08-16 17:41 0000