From: Mitch Pirtle <mitch.pirtle@gmail.com>
To: pgsql-performance@postgresql.org
Subject: PG versus FreeBSD, startup and connections problems
Date: Tue, 25 Jan 2005 13:19:48 -0500
Message-ID: <330532b605012510193eb73b72@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mitch.pirtle@gmail.com
Subject: Re: PG versus FreeBSD, startup and connections problems
In-Reply-To: <330532b605012510193eb73b72@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox