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

MAX_CONNECTIONS ??

From: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
To: GENERAL <pgsql-general(at)postgresql(dot)org>, admin <pgsql-admin(at)postgresql(dot)org>
Subject: MAX_CONNECTIONS ??
Date: 2008-11-12 16:05:19
Message-ID: 234747.33153.qm@web52501.mail.re2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
I need help to alter max_connections em my database, this parameter stay in defalt  MAX_CONNECTIONS=100
I want to change for MAX_CONNECTIONS=300.
about parameters below, need to change anything?

1 -sysctl.conf

kernel.shmmax = 68719476736
kernel.shmall = 4294967296
# - Memory -

2-Postgresql.conf
shared_buffers = 2048MB                                          
temp_buffers = 12MB                                                    
work_mem = 12MB                     
maintenance_work_mem = 128MB                          
max_fsm_pages =   4000000                               
max_fsm_relations = 5000            
                                  
Thanks for help



      Novos endere├žos, o Yahoo! que voc├¬ conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com.
http://br.new.mail.yahoo.com/addresses

Responses

pgsql-admin by date

Next:From: Naomi WalkerDate: 2008-11-12 17:06:01
Subject: Upgrade in Place
Previous:From: Sean BrownDate: 2008-11-12 14:30:47
Subject: Re: function executes sql 100 times longer it should

pgsql-general by date

Next:From: Alan HodgsonDate: 2008-11-12 16:06:54
Subject: Re: merge 2 dumps
Previous:From: Ivan Sergio BorgonovoDate: 2008-11-12 16:01:19
Subject: sequence not restarting in a for loop (actually semi-random numbers)

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