<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "http://bugs.gentoo.org/bugzilla.dtd">

<bugzilla version="2.22.7"
          urlbase="http://bugs.gentoo.org/"
          maintainer="bugzilla@gentoo.org"
>

    <bug>
          <bug_id>189141</bug_id>
          
          <creation_ts>2007-08-16 17:41 0000</creation_ts>
          <short_desc>postgresql on Gentoo/FreeBSD defaults to 512 connections which is more than the default kernel allows</short_desc>
          <delta_ts>2007-09-23 00:26:09 0000</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>1</classification_id>
          <classification>Unclassified</classification>
          <product>Gentoo/Alt</product>
          <component>FreeBSD</component>
          <version>unspecified</version>
          <rep_platform>All</rep_platform>
          <op_sys>FreeBSD</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>FIXED</resolution>
          
          
          
          <priority>P2</priority>
          <bug_severity>normal</bug_severity>
          <target_milestone>---</target_milestone>
          
          
          
          <everconfirmed>1</everconfirmed>
          <reporter>jshupe@gmail.com</reporter>
          <assigned_to>bsd@gentoo.org</assigned_to>
          <cc>esigra@gmail.com</cc>

      

      
          <long_desc isprivate="0">
            <who>jshupe@gmail.com</who>
            <bug_when>2007-08-16 17:41:23 0000</bug_when>
            <thetext>The FreeBSD kernel has a limit of 60 semaphores out of the box, so postgres can&apos;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
&lt; PGOPTS=&quot;-N 512 -B 1024&quot;
---
&gt; PGOPTS=&quot;-N 40 -B 1024&quot;


Reproducible: Always</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>uberlord@gentoo.org</who>
            <bug_when>2007-08-17 15:09:26 0000</bug_when>
            <thetext>Fixed, thanks.</thetext>
          </long_desc>
      
    </bug>

</bugzilla>