Subject: Re: postgresql won't terminate
To: Jan Danielsson <jan.danielsson@gmail.com>
From: Ben Collver <collver@peak.org>
List: netbsd-users
Date: 02/08/2006 06:27:36
Hello,

What does the following command output?

pkg_info -B postgresql80-server | grep ^PG

It looks like pkgsrc/postgresql80-server/files/pgsql.sh aka rc.d/pgsql
looks for the PID file in the data subdirectory of the PGUSER home
directory.  Is your PGUSER home directory the same path as $PGHOME/data?
The Makefile defaults PGHOME to ${PREFIX}/${PGUSER}.  I assume /var is
not your ${PREFIX}.  How did you override PGHOME?  Does PGHOME exist?
Have you stored data in postgres yet?  Did you see anything interesting
in /var/pgsql/errlog?

Cheers,

Ben

On Wed, Feb 08, 2006 at 12:31:06PM +0100, Jan Danielsson wrote:
>    Running postgresql 8.0.5 on NetBSD/i386 3.0. When I run
> "/etc/rc.d/pgsql stop", it complains that /var/pgsql/data/postmaster.pid
> does not exist. It doesn't exist, and it doesn't exist in /var/run
> either. In fact, the only way to kill it is via "kill" using root.