Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id F16A964FD2A
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 12 Nov 2008 12:05:24 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 47048-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 12 Nov 2008 12:05:22 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from web52501.mail.re2.yahoo.com (web52501.mail.re2.yahoo.com
	[206.190.48.184])
	by mail.postgresql.org (Postfix) with SMTP id D79B964FCD8
	for <pgsql-admin@postgresql.org>; Wed, 12 Nov 2008 12:05:21 -0400 (AST)
Received: (qmail 34059 invoked by uid 60001); 12 Nov 2008 16:05:20 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=2Qn+vD8K/qsdOxoaSjQROs1VNNCptCYk5cPdiu8vPGSQYTQ9WnucqC2QxsgA2DODTM0nZc5NXpP1iL6qWJVakkdi8qbmzQZvfKoyTdKk9zDAitBHEO8npBFCUZZ5fhgEPaFTcwUEBopRA/c/hnZzq+AUaaqGkZgw/h9fmtqytt0=;
X-YMail-OSG: 
 Jkz2jFEVM1kU.._wmYlPcVYNFry_DfAzFBxXB_7xyWgnwXsXBYwVWNiXjLEgzWL8udEuyCVagwkbHJz0Sh7YB4tftIVKFe20yhFdXRjPUv.tfVtnqew_ff9EruB21IhHhrpFMS3CEu5MeieeY__EeYkZdqnCyhwzmajs8s_UD51o5D4a5DRjip4y4KaqQw--
Received: from [189.17.249.3] by web52501.mail.re2.yahoo.com via HTTP;
	Wed, 12 Nov 2008 08:05:19 PST
X-Mailer: YahooMailRC/1155.29 YahooMailWebService/0.7.260.1
Date: Wed, 12 Nov 2008 08:05:19 -0800 (PST)
From: paulo matadr <saddoness@yahoo.com.br>
Subject: MAX_CONNECTIONS ??
To: GENERAL <pgsql-general@postgresql.org>, admin <pgsql-admin@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-6421731-1226505919=:33153"
Message-ID: <234747.33153.qm@web52501.mail.re2.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.807 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001, SUBJ_ALL_CAPS=1.806
X-Spam-Level: *
X-Archive-Number: 200811/64
X-Sequence-Number: 30718

--0-6421731-1226505919=:33153
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

I need help to alter max_connections em my database, this parameter stay in=
 defalt  MAX_CONNECTIONS=3D100=0AI want to change for MAX_CONNECTIONS=3D300=
.=0Aabout parameters below, need to change anything?=0A=0A1 -sysctl.conf=0A=
=0Akernel.shmmax =3D 68719476736=0Akernel.shmall =3D 4294967296=0A# - Memor=
y -=0A=0A2-Postgresql.conf=0Ashared_buffers =3D 2048MB                     =
                     =0Atemp_buffers =3D 12MB                              =
                      =0Awork_mem =3D 12MB                     =0Amaintenan=
ce_work_mem =3D 128MB                          =0Amax_fsm_pages =3D   40000=
00                               =0Amax_fsm_relations =3D 5000            =
=0A                                  =0AThanks for help=0A=0A=0A=0A      No=
vos endere=C3=A7os, o Yahoo! que voc=C3=AA conhece. Crie um email novo com =
a sua cara @ymail.com ou @rocketmail.com.=0Ahttp://br.new.mail.yahoo.com/ad=
dresses
--0-6421731-1226505919=:33153
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:times new roman,new york,times,serif;fon=
t-size:12pt"><div>I need help to alter max_connections em my database, this=
 parameter stay in defalt&nbsp; MAX_CONNECTIONS=3D100<br>I want to change f=
or MAX_CONNECTIONS=3D300.<br>about parameters below, need to change anythin=
g?<br><br>1 -sysctl.conf<br><br>kernel.shmmax =3D 68719476736<br>kernel.shm=
all =3D 4294967296<br># - Memory -<br><br>2-Postgresql.conf<br>shared_buffe=
rs =3D 2048MB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>temp_buffers =3D 12MB&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbs=
p;
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>work_mem =3D 12MB&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>maintenance_work_mem =3D 128M=
B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br=
>max_fsm_pages =3D&nbsp;&nbsp; 4000000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>ma=
x_fsm_relations =3D 5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;
 <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>Thanks for help<b=
r></div></div><br>=0A=0A=0A      <hr size=3D1>Novos endere=C3=A7os, o Yahoo=
! que voc=C3=AA conhece. <a href=3D"http://br.rd.yahoo.com/mail/taglines/ma=
il/*http://br.new.mail.yahoo.com/addresses">Crie um email novo</a> com a su=
a cara @ymail.com ou @rocketmail.com.</body></html>
--0-6421731-1226505919=:33153--