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_sock et = 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 3 3579
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_sock et = 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*******@postg resql.org
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_sock et = 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 YourEmailAddres sHere" to ma*******@postg resql.org)
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_sock et = 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
block.
should i close ResultSets and Connections in the catch block aswell?.
|
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 person 2, 1 can add 2 and then
they will be recognized as friends. I also want, if person 3 is
friends with 2, and goes to person 1's page, person 3...
|
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 specific database? Is there any
parameter?
Thanks in advance,
Do.
|
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 load the data by something
like that:
LOAD FROM "/pathto/artikel.data" OF DEL MODIFIED BY DATESISO CHARDEL0xbf
SAVECOUNT 50000
MESSAGES...
|
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 doing "No touch deployment"
so it's particularly important that the versioning works as it should as
assemblies otherwise do not get probed for.
...
| |
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 requests, this is
the code:
ServicePointManager.DefaultConnectionLimit = 10;
ThreadFunction()
|
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 hits the cap, the number for the
next year will be increase by 20 %. That is, if next year we hit
115,000 visas, 138,750 will be issued for the...
|
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 huge number of places and this woudl take me forever if i do
it indivisually, is there any way i can increase the timeout globally by
something like...
|
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 this possible? Please help.
Thanks
Kai
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |