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.