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

Re: 7.3b2 initdb fails with a semaphore error (solved)

From: Lalo Castro <laloc(at)cats(dot)ucsc(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 7.3b2 initdb fails with a semaphore error (solved)
Date: 2002-11-15 19:01:29
Message-ID: 3DD54489.2020303@cats.ucsc.edu (view raw or flat)
Thread:
Lists: pgsql-bugs
You could also recompile postgres with
./configure --with-maxbackends=N
Where N equals however many backends you want.


On Tue, 1 Oct 2002, Tom Lane wrote:

 > Mark Stosberg <mark(at)summersault(dot)com> writes:
 > > I think the bug here is that this message advertises that I can change
 > > the "max_connections" parameter to address this, but there does not
 > > appear to be a way to do this.  The max_connections option is located
 > > on my system at /usr/local/share/postgresql/postgresql.conf.sample
 > > (prior to initdb)
 >
 > Hmm ... actually, I don't think the max_connections parameter is used
 > during standalone operation.  It looks like the code uses a hardwired
 > value of "16".  We could reduce that (there's probably no good reason
 > why it's not "1"), but I suspect your SEMMAX parameter is so small
 > it will fail anyway :-(
 >
 > Would you try changing "16" to "1" in InitCommunication() in
 > src/backend/utils/init/postinit.c, and see if that helps on your
 > setup?

Tom,

I tried this change, and was able to successfully "initdb" after that,
and then run "psql" after that. I'm running this installation on a home
machine for light use, so I may not need 16 backends anyway.

If you're correct that there is no need to have more than 1 backend
during "initdb", then perhaps this could be turned into a patch. My
simple patch is below:

  -mark

http://mark.stosberg.com/

################################

--- postinit.c.orig     Wed Oct  2 12:56:13 2002
+++ postinit.c  Wed Oct  2 12:56:42 2002
@@ -176,7 +176,7 @@
                  * postmaster.  Create private "shmem" and semaphores. 
  Setting
                  * MaxBackends = 16 is arbitrary.
                  */
-               CreateSharedMemoryAndSemaphores(true, 16, 0);
+               CreateSharedMemoryAndSemaphores(true, 1, 0);
         }
  }








-- 
Lalo Castro
Programmer/Analyst
McHenry Library
(831) 459-5208


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-11-15 23:05:42
Subject: Re: copy works, \copy doesn't
Previous:From: Marc G. FournierDate: 2002-11-15 18:57:25
Subject: Re: Get a CD

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