X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ADA1F3A5838 for ; Tue, 25 Jan 2005 18:19:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00339-05 for ; Tue, 25 Jan 2005 18:19:56 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.193]) by svr1.postgresql.org (Postfix) with ESMTP id 6BDA03A5855 for ; Tue, 25 Jan 2005 18:19:49 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 40so86555wri for ; Tue, 25 Jan 2005 10:19:48 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=RXiihjF3qIZlR5k5PoTL3/VK2Pknaq5rIAGid4PEnGdX8G/yOh9nUzergKnPqeKRFickNbuclwvdaHY+7v3COsRkgRrw9HxdiuHklQI8LNOQ4oThoMPDdYGaxFyYrbycnqfHummwhPIHxoP3OdMCqZvXUyf5/O2Yi5WUu7PoCqg= Received: by 10.54.20.70 with SMTP id 70mr46462wrt; Tue, 25 Jan 2005 10:19:48 -0800 (PST) Received: by 10.54.59.22 with HTTP; Tue, 25 Jan 2005 10:19:48 -0800 (PST) Message-ID: <330532b605012510193eb73b72@mail.gmail.com> Date: Tue, 25 Jan 2005 13:19:48 -0500 From: Mitch Pirtle Reply-To: Mitch Pirtle To: pgsql-performance@postgresql.org Subject: PG versus FreeBSD, startup and connections problems Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.045 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/477 X-Sequence-Number: 10167 Hi gang, I just inherited a FreeBSD box, and it is horribly sick. So we moved everything to a new machine (power supply failures) and finally got stuff running again. Ok, for two days (rimshot) Here are the two problems, and for the life of me I cannot find any documentation on either: 1) freebsd will only let PostgreSQL have 38 connections at a time, regardless of kernel settings or postgresql.conf settings. Where exactly (and how, exactly) does one remedy that problem? 2) As of this morning, the machine was down again, this time apache fired up normally but pg refuses to start - without errors. When I start with postmaster on the CLI I also get no errors, just no postmaster. Why am I not seeing the errors, is this a FreeBSD or PostgreSQL issue? For example: $ pg_ctl start postmaster successfully started $ pg_ctl status pg_ctl: postmaster or postgres not running OR: $ postmaster -D /usr/local/pgsql/data $ (no response) There are no errors in /var/log/pgsql either, so I have absolutely no idea how to troubleshoot :-( -- Mitch