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

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Lalo Castro <laloc(at)cats(dot)ucsc(dot)edu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 7.3b2 initdb fails with a semaphore error (solved)
Date: 2002-11-16 19:13:43
Message-ID: 200211161913.gAGJDiC12654@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
This has been done already and will appear in 7.3 final.

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

Lalo Castro wrote:
> 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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
> 

-- 
  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-bugs by date

Next:From: Neil ConwayDate: 2002-11-16 19:30:59
Subject: Re: OSX 10.2.2 and beta 5
Previous:From: Bruce MomjianDate: 2002-11-16 19:03:27
Subject: Re: OSX 10.2.2 and beta 5

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