From ddelao@ou.edu Mon Jun 8 11:26:36 2026 X-Original-To: pgsql-docs@postgresql.org Received: from hubmail.ou.edu (hubmail.oulan.ou.edu [129.15.87.252]) by postgresql.org (Postfix) with ESMTP id 2223647655E for ; Thu, 6 Mar 2003 13:20:17 -0500 (EST) Received: by hubmail.oulan.ou.edu with Internet Mail Service (5.5.2656.59) id ; Thu, 6 Mar 2003 12:20:16 -0600 Message-ID: From: "Delao, Darryl W" To: pgsql-docs@postgresql.org Subject: Compiling postgresql Date: Thu, 6 Mar 2003 12:16:35 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2E40C.859F3820" X-Archive-Number: 200303/9 X-Sequence-Number: 1687 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C2E40C.859F3820 Content-Type: text/plain As it stands, I have postgres set to a max limit of 512 users. I have been told and read some material to where anything above 512 users may require re compiling postgres. I have installed postgres via a RPM and therefore have never had to compile postgres before. My main concern is what would I need to change other than the user limit to make postgres to where it would accept connections higher than 512 and what steps are involved in the compiling process. Right now, if I try to set the user limit above 512, postgres simply will not start. Any help is greatly appreciated. Thank you! Darryl ------_=_NextPart_001_01C2E40C.859F3820 Content-Type: text/html Content-Transfer-Encoding: quoted-printable

As it stands, I have postgres set to a max limit of 512 users.  = I have been told and read some material to where anything above 512 users may require re compiling postgres.  I have installed postgres via a RPM and therefore have never had to compile postgres be= fore.  My main concern is what would I need to change other than the user limit to make postgres to where it would accept connections higher than 512 and what steps are involved in the compiling process.  <= /span>Right now, if I try to set the user limit above 512, postgre= s simply will not start.  Any he= lp is greatly appreciated. 

 

Thank you!

Darryl

 

------_=_NextPart_001_01C2E40C.859F3820-- From tgl@sss.pgh.pa.us Mon Jun 8 11:26:36 2026 X-Original-To: pgsql-docs@postgresql.org Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 275374764DE for ; Thu, 6 Mar 2003 15:59:23 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.8/8.12.8) with ESMTP id h26KxNx6018085; Thu, 6 Mar 2003 15:59:23 -0500 (EST) To: "Delao, Darryl W" Cc: pgsql-docs@postgresql.org Subject: Re: Compiling postgresql In-reply-to: References: Comments: In-reply-to "Delao, Darryl W" message dated "Thu, 06 Mar 2003 12:16:35 -0600" Date: Thu, 06 Mar 2003 15:59:23 -0500 Message-ID: <18084.1046984363@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200303/11 X-Sequence-Number: 1689 "Delao, Darryl W" writes: > never had to compile postgres before. My main concern is what would I need > to change other than the user limit to make postgres to where it would > accept connections higher than 512 and what steps are involved in the > compiling process. Right now, if I try to set the user limit above 512, > postgres simply will not start. Any help is greatly appreciated. You mean 512 concurrent connections? It sounds to me like you are running into kernel-level limits on amount of shared memory or number of semaphores. But without seeing the error message the postmaster puts out, it's hard to be sure. See the discussion about "Managing Kernel Resources" in the PG Administrator's Guide. There has been no compile-time limit on number of connections for several releases now, so I doubt you need to recompile. (If you do, you are overdue for an update.) regards, tom lane From ddelao@ou.edu Mon Jun 8 11:26:35 2026 X-Original-To: pgsql-docs@postgresql.org Received: from hubmail.ou.edu (hubmail.oulan.ou.edu [129.15.87.252]) by postgresql.org (Postfix) with ESMTP id DD0E6476483 for ; Thu, 6 Mar 2003 16:05:57 -0500 (EST) Received: by hubmail.oulan.ou.edu with Internet Mail Service (5.5.2656.59) id ; Thu, 6 Mar 2003 15:05:58 -0600 Message-ID: From: "Delao, Darryl W" To: 'Tom Lane' , "Delao, Darryl W" Cc: pgsql-docs@postgresql.org Subject: Re: Compiling postgresql Date: Thu, 6 Mar 2003 15:02:16 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-Type: text/plain X-Archive-Number: 200303/12 X-Sequence-Number: 1690 Yes, 512 concurrent connections. I have the db running on a dual xeon 2.4 ghz machine with 6 gig of ram...basically, im not even touching the ram at this point. If I wanted to increase to say 1024, then your saying I need to look into the kernel-level limits? When I tried to set it to 1024 before, the postgres service wouldn't even start. Do you think the reason for that was some sort of kernel level problem or setting that needed to be tweaked? Thanks, Darryl -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Thursday, March 06, 2003 2:59 PM To: Delao, Darryl W Cc: pgsql-docs@postgresql.org Subject: Re: [DOCS] Compiling postgresql "Delao, Darryl W" writes: > never had to compile postgres before. My main concern is what would I need > to change other than the user limit to make postgres to where it would > accept connections higher than 512 and what steps are involved in the > compiling process. Right now, if I try to set the user limit above 512, > postgres simply will not start. Any help is greatly appreciated. You mean 512 concurrent connections? It sounds to me like you are running into kernel-level limits on amount of shared memory or number of semaphores. But without seeing the error message the postmaster puts out, it's hard to be sure. See the discussion about "Managing Kernel Resources" in the PG Administrator's Guide. There has been no compile-time limit on number of connections for several releases now, so I doubt you need to recompile. (If you do, you are overdue for an update.) regards, tom lane From neilc@samurai.com Mon Jun 8 11:26:35 2026 X-Original-To: pgsql-docs@postgresql.org Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by postgresql.org (Postfix) with ESMTP id 0CAC04762CF for ; Thu, 6 Mar 2003 19:44:21 -0500 (EST) Received: from DU150.N224.ResNet.QueensU.CA (DU150.N224.ResNet.QueensU.CA [130.15.224.150]) by bob.samurai.com (Postfix) with ESMTP id 1557B1F27; Thu, 6 Mar 2003 19:44:20 -0500 (EST) Subject: Re: Compiling postgresql From: Neil Conway To: "Delao, Darryl W" Cc: 'Tom Lane' , pgsql-docs@postgresql.org In-Reply-To: References: Content-Type: text/plain Organization: Message-Id: <1046997854.10615.63.camel@tokyo> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 Date: 06 Mar 2003 19:44:14 -0500 Content-Transfer-Encoding: 7bit X-Archive-Number: 200303/14 X-Sequence-Number: 1692 On Thu, 2003-03-06 at 16:02, Delao, Darryl W wrote: > Yes, 512 concurrent connections. I have the db running on a dual xeon 2.4 > ghz machine with 6 gig of ram...basically, im not even touching the ram at > this point. If I wanted to increase to say 1024, then your saying I need to > look into the kernel-level limits? No, I think Tom is saying that you should provide the error message you're encountering. For more information on configuring kernel-level shared memory settings, see http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/kernel-resources.html Cheers, Neil P.S. User support should be done on lists like pgsql-general or pgsql-novice, not pgsql-docs -- Neil Conway || PGP Key ID: DB3C29FC