473,221 Members | 1,983 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,221 software developers and data experts.

How to increase number of connections to 7.2.1

I need to increase the number of connections to PostgreSQL 7.2.1.

I have tried changing the value of max_connections in Postgresql.conf. It
was commented out (as are all other entries except "tcpip_socket = true").
Setting it to any other value that the default 32 resulted in the server
failing to restart.

I know we should upgrade from 7.2.1 and that is going to happen soon, but
this is a production server and I need a solution sooner.

Thanks in advance,
Edwin New
Analyst Programmer
Toll - Integrated Business Systems
43 - 63 Princes Highway,
Doveton, VIC. 3175
Ph: 03 8710 0858
Fax: 03 9793 3970
Mobile: 0417 341 074
Email: ed*******@toll.com.au
Nov 23 '05 #1
3 3560
On Mon, 2004-10-18 at 11:15, Edwin New wrote:
I have tried changing the value of max_connections in
Postgresql.conf. It was commented out (as are all other entries
except "tcpip_socket = true"). Setting it to any other value that the
default 32 resulted in the server failing to restart.


Without knowing the error message you got, it's possible that you didn't
increase shared_buffers to correspond to the newly increased
max_connections. If you increase shared_buffers, then you're probably
exceeding the system SysV shared memory restrictions. See

http://www.postgresql.org/docs/7.4/s...s.html#SYSVIPC

-Neil

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #2
Edwin New <ed*******@toll.com.au> writes:
I need to increase the number of connections to PostgreSQL 7.2.1.
I have tried changing the value of max_connections in
Postgresql.conf. It was commented out (as are all other entries
except "tcpip_socket = true"). Setting it to any other value that the
default 32 resulted in the server failing to restart.


1) Make sure your shared_buffers setting is big enough to handle your
desired connection limit.

2) Make sure your kernel's shared memory limits allow for your
shared_buffers setting.

If you can't get it to start, please post the server log entries from
the failed attempt--otherwise we have nothing to go on.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #3
What error do you get when the server fails to restart? It sounds like
it could be a kernel resource issue. See:

http://www.postgresql.org/docs/7.4/s...resources.html

-tfo

On Oct 17, 2004, at 8:15 PM, Edwin New wrote:
I need to increase the number of connections to PostgreSQL 7.2.1.

*

I have tried changing the value of max_connections in
Postgresql.conf.* It was commented out (as are all other entries
except "tcpip_socket = true"). *Setting it to any other value that the
default 32 resulted in the server failing to restart.

*

I know we should upgrade from 7.2.1 and that is going to happen soon,
but this is a production server and I need a solution sooner.

*

Thanks in advance,

Edwin New
Analyst Programmer


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: sumithradevi | last post by:
Hello Friends, I am getting the following error. java.sql.SQLException: ORA-00020: maximum number of processes (100) exceeded I am closing all my resultsets and all my connections in the try...
1
by: Sam G | last post by:
Hi folks, What I'd like to do for a website I'm designing with PHP/MySQL is have a number of registered users who can make friends with each other... so if person 1 wants to be friends with...
2
by: Do Park via SQLMonster.com | last post by:
Hello all, A software that connects SQL Server via ODBC uses 12 process at the same time when I look at the process info(panel). Is it possible to increase number of process (or thread) for a...
5
by: Olaf Gschweng | last post by:
We're new into DB2 and have some problem with DB2 8.1 (?) on a Linux system. We load some big tables of a DB2 database from files every day. We do a "DELETE FROM table" for each table and then we...
3
by: Henrik Dahl | last post by:
Hello! In VS.Net 2003 it was easy to make the build number to increase automatically at each build. Therefore it was easy to ensure that only one assembly would get a certain build number. I'm...
2
by: Basel | last post by:
Hi All! I'm having a problem with a growing number of connections. my app generates http requests and reads responses. the app creates large number of threads (100 or more) that generates the...
2
by: special10101 | last post by:
The Immigration Bill being sent to reconciliation includes the following: 1) Doubling the current number of H1-B visas from 65,000/year to 115,000/year. 2) Every year that the number of visas...
4
by: =?Utf-8?B?c2FtZWVy?= | last post by:
environment : .net framework 1.1, ado.net, visual studio 2003, vb, sqlsever 2000, winforms, webforms I want to increase the timout of the webservice in the application which is being used in a...
2
by: kai | last post by:
Hi, I use VB 2008 as front end, SQL Server 2005/2008 as back end, I want control number of cucurrent users log on to the database, I am trying to use a stored procedure, but it did not work. Is...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.