Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA18645; Thu, 11 Jul 91 16:48:53 -0700
Message-Id: <9107112348.AA18645@postgres.Berkeley.EDU>
From: dmh@goanna.cs.rmit.OZ.AU
Subject: postgres system problems
To: postgres@postgres.berkeley.edu
Date: Fri, 12 Jul 91 09:48:46 +1000
From: dmh@goanna.cs.rmit.OZ.AU


Hi, we are using postgres for our Masters By Coursework here at RMIT but we are
having a few problems. Every day the postgres backend seems to stop working
properly. Sometimes there is no response for particular DBs but others work
fine. Sometimes error messages are returned for all requests. I usually kill
and restart the postmaster and things start working again (for a while).

I don't have all the error messages people have been getting but one of them is:

could not lock buffer segment

Another thing I have noticed since we've been running postgres is that normal
users (!root) cannot run ipcs properly, eg:

numbat:719% ipcs
IPC status from numbat as of Fri Jul 12 09:44:41 1991
T     ID     KEY        MODE       OWNER    GROUP
Message Queues:
Shared Memory:
shmctl: Permission denied

We have a Sun SPARCserver2 running SUNOS 4.1.1 Rev B.

Does anyone have any ideas about what the problem is or how to solve it? It is
very annoying having to continually check the system to make sure it is
working.

	Thanks in advance, dmh

Darren Hosking			ACSnet: dmh@goanna.cs.rmit.oz	 
Department Of Computer Science	ARPA:   dmh%goanna.cs.rmit.oz.au@uunet.uu.net
RMIT				CSNET:  dmh%goanna.cs.rmit.oz.au@australia
GPO Box 2476V			UUCP:   ...!uunet!goanna.cs.rmit.oz.au!dmh
Melbourne Vic., Australia 3001	PH: +61 3 660 3299 FAX: +61 3 662 1617