pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Building new FreeBSD box - some assistance needed
2+ messages / 2 participants
[nested] [flat]

* Building new FreeBSD box - some assistance needed
@ 2006-07-31 18:52 Benjamin Krajmalnik <kraj@illumen.com>
  2006-07-31 18:57 ` Re: Building new FreeBSD box - some assistance needed Larry Rosenman <ler@lerctr.org>
  0 siblings, 1 reply; 2+ messages in thread

From: Benjamin Krajmalnik @ 2006-07-31 18:52 UTC (permalink / raw)
  To: pgsql-admin

I am building a new FreeBSD 6.1 box to migrate from the Windows
PostgreSQL.
I am having some issues getting PostgreSQL to load when I try to
duplicate my configuration as running on the Windows box.
 
I have made the modifications to loader.conf.  All of the SHM values are
being set properly (as I can see them in sysctl -a with the new values),
but the sem values are not being updated.
I have limited the # of connections to bypass this minor problem, but
would like to be able to bump it.
 
Do I need to rebuild the kernel for these values to take effect?

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Building new FreeBSD box - some assistance needed
  2006-07-31 18:52 Building new FreeBSD box - some assistance needed Benjamin Krajmalnik <kraj@illumen.com>
@ 2006-07-31 18:57 ` Larry Rosenman <ler@lerctr.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Larry Rosenman @ 2006-07-31 18:57 UTC (permalink / raw)
  To: 'Benjamin Krajmalnik' <kraj@illumen.com>; pgsql-admin

I'm setting my semaphores on FreeBSD/amd64 as follows:
$ more /boot/loader.conf
geom_mirror_load="YES"
kern.ipc.semmns=4096
kern.ipc.semmni=2048
machdep.hyperthreading_allowed=1
$

(the geom_mirror_load and machdep.hyperthreading_allowed are not relevant
for this, but that's my entire
/boot/loader.conf file).
 
How may I help?
 
LER
 

--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 512-248-2683                 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893


 

  _____  

From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Benjamin Krajmalnik
Sent: Monday, July 31, 2006 1:52 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Building new FreeBSD box - some assistance needed


I am building a new FreeBSD 6.1 box to migrate from the Windows PostgreSQL.
I am having some issues getting PostgreSQL to load when I try to duplicate
my configuration as running on the Windows box.
 
I have made the modifications to loader.conf.  All of the SHM values are
being set properly (as I can see them in sysctl -a with the new values), but
the sem values are not being updated.
I have limited the # of connections to bypass this minor problem, but would
like to be able to bump it.
 
Do I need to rebuild the kernel for these values to take effect?

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-07-31 18:57 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-31 18:52 Building new FreeBSD box - some assistance needed Benjamin Krajmalnik <kraj@illumen.com>
2006-07-31 18:57 ` Larry Rosenman <ler@lerctr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox