Skip site navigation (1) Skip section navigation (2)

Re: PgSQL74b2: initdb fails (max_connections)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: j(dot)richter(at)wallstreet-develop(dot)de
Cc: pgsql-ports(at)postgresql(dot)org
Subject: Re: PgSQL74b2: initdb fails (max_connections)
Date: 2003-09-04 21:54:13
Message-ID: 200309042154.h84LsDM27473@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-ports
This is fixed in CVS and will be in beta3.

---------------------------------------------------------------------------

Janko Richter wrote:
> On FreeBSD 5.1 using PgSQL 7.4b2 initdb failed with:
> 
> su-2.05b$ ./initdb -D /data/pgsql
> The files belonging to this database system will be owned by user 
> "postgres".
> This user must also own the server process.
> 
> The database cluster will be initialized with locale C.
> 
> fixing permissions on existing directory /data/pgsql... ok
> creating directory /data/pgsql/base... ok
> creating directory /data/pgsql/global... ok
> creating directory /data/pgsql/pg_xlog... ok
> creating directory /data/pgsql/pg_clog... ok
> selecting default shared_buffers... 1000
> selecting default max_connections... 40
> creating configuration files... ok
> creating template1 database in /data/pgsql/base/1... ./postgres -boot 
> -x1 -F -D/data/pgsql  template1
> FATAL:  could not create semaphores: No space left on device
> DETAIL:  Failed syscall was semget(4, 17, 03600).
> HINT:  This error does *not* mean that you have run out of disk space.
> It occurs when either the system limit for the maximum number of 
> semaphore sets (SEMMNI), or the system wide maximum number of semaphores 
> (SEMMNS), would be exceeded.  You need to raise the respective kernel 
> parameter.  Alternatively, reduce PostgreSQL's consumption of semaphores 
> by reducing its max_connections parameter (currently 100).
> The PostgreSQL documentation contains more information about configuring 
> your system for PostgreSQL.
> 
> initdb: failed
> 
> 
> Why does initdb use max_connections=100, but "selecting default 
> max_connections" gives 40 ?
> 
> Regards,
> --
> Janko Richter
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-ports by date

Next:From: Tom LaneDate: 2003-09-05 00:56:15
Subject: Re: Problem under Cygwin after Cygwin update
Previous:From: Thomas WegnerDate: 2003-09-03 16:08:17
Subject: Problem under Cygwin after Cygwin update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group