189141 – postgresql on Gentoo/FreeBSD defaults to 512 connections which is more than the default kernel allows

Bug 189141 - postgresql on Gentoo/FreeBSD defaults to 512 connections which is more than the default kernel allows

Summary: postgresql on Gentoo/FreeBSD defaults to 512 connections which is more than t...

Status:	RESOLVED FIXED

Alias:	None

Product:	Gentoo/Alt
Classification:	Unclassified
Component:	FreeBSD (show other bugs)
Hardware:	All FreeBSD

Importance:	High normal (vote)
Assignee:	Gentoo/BSD Team

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2007-08-16 17:41 UTC by Jason
Modified:	2007-09-23 00:26 UTC (History)
CC List:	1 user (show)

See Also:
Package list:
Runtime testing required:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Jason 2007-08-16 17:41:23 UTC

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 Roy Marples (RETIRED) gentoo-dev

2007-08-17 15:09:26 UTC

Fixed, thanks.