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