[prev in list] [next in list] [prev in thread] [next in thread] 

List:       debian-user
Subject:    Re: Default PGBUFFERS value is too low.
From:       Bob Bernstein <ruptured-duck () home ! com>
Date:       1999-10-28 11:27:18
[Download RAW message or body]

"Oliver Elphick" <olly@lfix.co.uk> wrote:

> >Now /var/log/postgres.log tells me:
> >
> >'/usr/lib/postgresql/bin/postmaster: -B must be at least twice -N and at
> >least 16.'

> -B takes the value of $PGBUFFERS from /etc/postgresql/postmaster.init.  Its
> default value is 64.  -N sets the maximum number of backend processes that
> may be started.  Its default is 64 as of 6.5.2-1, so it is surprising that
> no-one else has met the error you have.  There is no provision to set this
> in postmaster.init - an omission that I shall rectify.
> 
> Increase the value of PGBUFFERS.

Making it 128 did the trick. I don't know for sure what previous version I had
installed; it was potato as of a couple/few weeks ago. Whatever it was, it did
not show this problem.

(In that prior version postgres's home dir in etc/passwd was /var/postgres and
that wasn't a problem either, although I've made /var/lib/postgres now.)

Thanks!


--
Bob Bernstein                http://members.home.net/ruptured-duck
at
Esmond, RI, USA

"I think it's a bad treaty." Henry Kissinger in The Washington Post, 10/14/99.


-- 
Unsubscribe?  mail -s unsubscribe debian-user-request@lists.debian.org < /dev/null

[prev in list] [next in list] [prev in thread] [next in thread]