[traven-tech] postgres change?

[john duda]

ok, so according to the postgres docs at
http://developer.postgresql.org/pgdocs/postgres/kernel-resources.html:

	The default maximum segment size is 32 MB, which is only
	adequate for small PostgreSQL installations.

does anyone mind if i bump up the amount of shhmax allowed in the
kernel to say, 48MB (it's at 32MB now)?

-john



On Tue, Oct 14, 2008 at 10:31:29AM +0100, Chris wrote:
> Hi John
> 
> On Mon 13-Oct-2008 at 03:56:59PM -0700, john duda wrote:
> > i have a backup script which doesn't seem to be
> > working....i'm getting this error....
> > 
> > pg_dump: [archiver (db)] connection to database "earth"
> > failed: FATAL:  connection limit exceeded for
> > non-superusers
> 
> Yeah, someone upgraded postgres and then I couldn't get it
> started without changing some settings, see:
> 
>   http://lists.indymedia.org/pipermail/traven-tech/2008-October/1006-jr.html
> 
> If anyone can improve on these setting please feel free to
> do so!
> 
> Chris

-- 

this is where my public key can be found:
gpg --keyserver pgp.mit.edu --recv-keys 03817826
Key fingerprint = 6C11 8D70 2ADE EFA9 498D  72CB 77EA 391A 0381 7826